DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PLS-000201 error when executing a remote stored procedure through generic connectity

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Question 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 ...

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Stored procedures aren't supported in Generic Connectivity.
    See http://download-west.oracle.com/docs...enco.htm#10736
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Dec 2001
    Posts
    141
    Originally posted by ales
    Stored procedures aren't supported in Generic Connectivity.
    See http://download-west.oracle.com/docs...enco.htm#10736
    Thanks a lot for your reply ! And your responsiveness ...
    It helps me a lot !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width