PLS-000201 error when executing a remote stored procedure through generic connectity
Hi all !
We've used the generic connectivity (hsodbc configuration) between an Oracle 8.1.7 database on Solaris and a SQLServer database, and thanks to it, we can select, insert and update data in SQLServer tables through a database link.
We're trying to execute a remote stored procedure based on SQLServer database, and we're getting a PLS-000201 error (identifier must be declared).
The stored procedure executes correctly on the SQL Server side and was created by the account dbo.
We've tried the following syntaxes (None of them work ...).
Any ideas ?
Thanks a lot in advance ...
Stored procedures aren't supported in Generic Connectivity.
The whole difference between a little boy and an adult man is the price of toys
Thanks a lot for your reply ! And your responsiveness ...
It helps me a lot !
Click Here to Expand Forum to Full Width