CRYSTAL REPORT 10 & Oracle 9i: error ORA-00936

[Prisca31]

In a hand:
I created a package with stored procedures, each one containing a refcursor in output and at least 1 parameter (number or varchar2) for input.
I tested each one of my procs in sqlplus and they all work.

Other hand:
I have an existing report with a main procedure and composed of several subreports using for each one, another one of my stored procedures.

I want to make an evolution in some subreports and i need to add 2 new parameters. I did it in my package: i added both them in the main procedure and also in each procedure used by the 2 subreports i have to modify.
I tested them again in sqlplus and they seem to work.

Problem: when i want to update my report with the modified package, i have an error : "Error of search engine: 'ORA-00936: missing expression ORA-06512 at "BDK.BDKPEQSR", line 81 ORA-06512: at line 1'"
If i ignore this error, crystal bugs and shuts down. i have to restart crystal and open my report again.

NOTE: BDK is the name of my Oracle schema and BDKPEQSR is the name of my package
I don't really understand where the problem is... Somebody can help me please?

 

[SantaMufasa]

Prisca,

Many of us here do not have access to (or use) Crystal Reports. If your code works fine in SQL*Plus, then I suggest that you also post your question in the forum Business Objects: Crystal Reports 2 Data Access Forum, by clicking on this link that I provided for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]