8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Heterogeneous Services - Generic Connectivity In Oracle9i


ars said...

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.
ars1364@gmail.com

Tim... said...

Hi.

I would expect something like this, but I don't know if I've ever done it.

BEGIN
procedure_name@link_name(7788);
END;
/

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.