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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal/Oracle stored procedures

Status
Not open for further replies.

urgent72

Programmer
Jun 3, 2004
15
US
HI,
I have a very urgent issue to be addressed please can any body help.
I have Oracle Stored procedures that need to be run using crystal reports 10.
I was upgraded from crystal reports 8.5 to 10.While i was running 8.5 i have created a test curser and was able to run my reports.I was able to run even when upgraded to 10.

The problem is now my procedures are moved to a different schema.So i have created a new test cursor and compiled my proceduress.My procedures are fine with out any errors.but when i try to run my reprts it gives me a

Query engine error:HY000 [oracle][odbc][ora]ora06550
PLS00306 wrong number or types of arguments in call

Can any body please help

Thanks in advance for the helping hand

Thanks

 
Not sure what the test cursor has to do with it, but you might have to run a Database->Verify Database in the report.

If that fails try using the Database->Set Location and repoint to the SP.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top