CRYSTAL REPORT 10 & Oracle 9i: errors ORA-00936 and ORA-06512

[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?

 

[beltmanjr]

I would suggest to try and test only a single stored procedure with crystal first. I guess it will fail.

As I am not working with stored procedures I can only guess that the parameters you created in the stored procedures are causing the problem as crystal doesnt pass them on creating an error in your expressions.

I guess you get the same error if you were to run them in sqlplus without giving the parameters.

 

[hilfy]

Did you verify the database after you changed the stored procedures? You might also try Set Datasource to re-direct the report to the new versions of the stored procs.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Prisca31]

Thank you. i found why there's this error.
When i try to verify database, i set all values to Null and in my sql request, Null is replaced by nothing.
clearly:
select parameter from dual
is replaced by
select from dual

that's why i have this error