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 ...).
exec "dbo"."proctest"@dblink_name
exec dbo.proctest@dblink_name
exec proctest@dblink_name
exec "proctest"@dblink_name
exec "DBO"."PROCTEST"@dblink_name
Any ideas ?
Thanks a lot in advance ...