Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trying to execute sql server database from oracle

user133578Oct 5 2010 — edited Oct 5 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2010
Added on Oct 5 2010
7 comments
1,878 views