Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling the sp from acuate professional! Urgent!!

Status
Not open for further replies.

novpg

Programmer
Dec 19, 2002
2
IN
The procedure (Oracle 8i) i am calling accepts 2 input paramters(integer) and returns one out parameter (integer). I am getting
"30 Stored Procedure does not have result set"
Basic Error:1011 2: Error generated by the connected data source... "
Could not set up Stored Procedure definition property in the AcStoredProcedueSource class)"
Do i need to use RefCursor for this output param?
 
You do not require a cursor for this. Make sure you have the correct DLLs and do not use AcStoredprocedure source
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top