i want to Execute a non-oracle procedure from Oracle database.
i am using DG4ODBC generic HS connectivity.
i want to execute a procedure located in sql 2000 from Oracle 11g database.
my remote stored procedure looks like this
sp_check_emp(empid in int)
My Heterogenous database link name , say HSLINK1
when i am triying to execute the procedure from Oracle with the following
syntax , its throwing an error invalid fuction.
SQL> call sp_check_emp@HSLINK1(1000) ;
can anyone provide info on executing a nonoracle procedure from oracle.
is there any way to execute a nonoracle procedure from oracle