Problem with REF CURSOR and Synonyms [message #39353] |
Wed, 10 July 2002 03:30 |
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 #39372 is a reply to message #39353] |
Fri, 12 July 2002 04:11 |
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
|
|
|