Home » SQL & PL/SQL » SQL & PL/SQL » Problem with REF CURSOR and Synonyms
Problem with REF CURSOR and Synonyms [message #39353] Wed, 10 July 2002 03:30 Go to next message
Nacho
Messages: 5
Registered: February 2002
Junior Member
Why I can't use a Synonym of a Stored Procedure which return various Ref Cursor and I get them in a RecordSet in VB.

If I use de Stored Procedure directly it works fine, but If i make a Synonym of that Stored Procedure fails i have an error...

Thx for the help

Excuse my English...

Nacho
Re: Problem with REF CURSOR and Synonyms [message #39357 is a reply to message #39353] Wed, 10 July 2002 09:03 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
What is the error message?
Re: Problem with REF CURSOR and Synonyms [message #39372 is a reply to message #39353] Fri, 12 July 2002 04:11 Go to previous message
Hari Babu
Messages: 2
Registered: July 2002
Junior Member
Hi,

You should be able to execute the procedure if you have granted the execute previliges to that procedure. It might be the problem with previliges. If you are still facing the problem provide the error message.

Thanks,
Hari
Previous Topic: Spooling
Next Topic: Can we use sql loader using pl/sql
Goto Forum:
  


Current Time: Sun Jul 21 21:15:08 CDT 2019