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'

 

[Turkbear]

Hi,
If you SP has an IN variable specified in its declaration, that is then assigned in the SP,then some NOT NULL value must be passed to it - usually by a parameter in the report - also try using the 'Native' Oracle connection and not ODBC - the ODBC connection method may limit your ability to conform to Oracle's needs..

It would help to see the SP code..





To Paraphrase:"The Help you get is proportional to the Help you give.."