ar sar
asked on
How do I call MySQL Stored Procedure from oracle using HS link ?
How do I call MySQL Stored Procedure from oracle using HS link ?
HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way !
Help please.
HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way !
Help please.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use DBMS_HS_PASSTHROUGH, without bind value, you must provide the VARCHAR2 parameter with the diferrents values you want to pass to mysql...
sample :
DBMS_HS_PASSTHROUGH.EXECUT E_IMMEDIAT E@HSLINK1( 'sp_sample _name"' || p1 || '"');
C.D.
sample :
DBMS_HS_PASSTHROUGH.EXECUT
C.D.
Hi!
As stated in chapter 2.2. here
as I pointed out in earlier post, then SP is not supported and therefore DBMS_HS_PASSTHROUGH won't help.
Regards,
Tomas Helgi
As stated in chapter 2.2. here
as I pointed out in earlier post, then SP is not supported and therefore DBMS_HS_PASSTHROUGH won't help.
Regards,
Tomas Helgi
ASKER
Thanks
There are some restrictions
Please, could you provide some sample of your source where the Stored Procedure are referenced? from pl/sql or Anonymous PL/SQL Block? and some detail about the MYSQL procedure : the CREATE PROCEDURE simpleproc (OUT param1 INT) syntaxe, function or routine.
Any oracle errors message?
Thank
C.D.