Link to home
Start Free TrialLog in
Avatar of ar sar
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.
ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi

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.
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.EXECUTE_IMMEDIATE@HSLINK1('sp_sample_name"' || p1 || '"');

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
Avatar of ar sar
ar sar

ASKER

Thanks