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!

I am attempting to create a stored

Status
Not open for further replies.

novpg

Programmer
Dec 19, 2002
2
IN
I am attempting to create a stored procedure report. I'm able to connect to the database (Oracle 8i) and select the desired procedure, but when prompted to enter sample parameter values and hit enter, I receive the
following errors:
"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)

I have also created the param(input & output) for the DataRow object.
 
Without knowing the SP, I am just taking a shot in the dark here. Try using Refcursor in oracle SP. If you use Refcursor then everything will be stored there and the reference of that (Refcursor) will be passed to Actuate to access the resultset.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top