| Ref cursor problem while calling from VB [message #372261] |
Tue, 23 January 2001 06:18  |
Sichu
Messages: 2
Registered: January 2001
|
Junior Member |
|
|
|
When I am calling a store procedure declared within a package which returns a ref cursor i am getting an error "object does not exist".I am not the owner of the package but has been granted execute permission on it. This is happening when calling from Vb connecting through ODBC.But it works fine when i execute it from the SQL*PLUS. Can anyone help?
|
|
|
|
| Re: Ref cursor problem while calling from VB [message #372265 is a reply to message #372261] |
Tue, 23 January 2001 13:17  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
Did you give the procedure name with qualifier.
like
call pkg_owner.my_package.my_proc....
if you have created synonym for that package then you can call it without pkg_owner qualifier
like...
Call my_package.my_proc...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
