trying to execute sql server database from oracle
My environment details:
EBS R12.0.6 with Database 10.2.0.4 ON AIX 5L(All 64-bit)-->hostname qa2
DG4MSQL -->hostname qa2
SQL Server 2005 ON Windows 2003 Server-->hostname devsrv
SID Name --> dg4msql
Database Link Name --> oratosql
Following are the link definition:
SQL> create public database link oratosql connect to
2 "tpl" identified by "inboxsql" using 'dg4msql';
Database link created.
SQL> select sysdate from dual@oratosql;
SYSDATE
-----------
10/5/2010 1
SQL>
Need to execute certain procedures on sql server database. I am able to select, insert, update statements but not able to execute procedures. Following error message I am getting:
SQL> execute "GetdateSys"@oratosql;
begin "GetdateSys"@oratosql; end;
ORA-06550: line 2, column 7:
PLS-00201: identifier 'GetdateSys@ORATOSQL' must be declared
ORA-06550: line 2, column 7:
PL/SQL: Statement ignored
SQL>
Note: I used "sys" user to create db-link and using "apps" user to select, update, execute e.t.c.
Please help me!!
Regards,
M.U.N.A