Home » RDBMS Server » Server Administration » Ref cursor problem while calling from VB
Ref cursor problem while calling from VB [message #372261] Tue, 23 January 2001 06:18 Go to next message
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 Go to previous messageGo to next message
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...
Re: Ref cursor problem while calling from VB [message #372270 is a reply to message #372261] Wed, 24 January 2001 05:18 Go to previous message
Sichu
Messages: 2
Registered: January 2001
Junior Member
yes we had created a synonym and still was having the same problem.
Previous Topic: updating multiple fields
Next Topic: Alternative of using cursor!!!!1
Goto Forum:
  


Current Time: Mon Dec 23 01:07:53 CST 2024