Crystal Reports Parameter Fields

[Mhossaim]

Whenever I try to add a database stored procedure in my crystal report using ODBC connection in the Database Expert menu, it keeps on asking me for a discrete value for the cursor I specified in my stored procedure. My stored procedure seems to be correct but there seems to be a confusion within my crystal report that can't differentiate my cursor from my parameter fields. When I leave my cursor value as null the following error message shows up and my database source does not get added:

Query Engine Error: 'HY000:[Oracle][ODBC][Ora]ORA-06550: line 1, column 49:
PLS-00567: Cannot passs NULL to a NOT NULL constrained formal parameter
ORA-06550: line 1, column 49:
PLS-00363: expression 'NULL' cannot be used as an assignment target
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'

 

[dyarwood]

This would probably be better posted in the Crystal Reports forum