Execute function from remote Oracle database through Oracle ODBC gateway

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Execute function from remote Oracle database through Oracle ODBC gateway

Garry Chen-2

Hi All,

                I am wondering how to call a postgresql function from Oracle database through Oracle ODBC gateway.  I have Oracle gateway configured and dblink named pgrempte created and test in a Oracle databse.  I can do select * from “ dbsec”.test_tab@pgremote in Oracle sqlplus and returned result set. How can I call postgresql function named “dbsec”.sp_proc(‘char’,’char2’) from remote Oracle database which has the dbllink named pgremte created?  Can it be done?

 

Thank you very much,

Garry