SQL & PL/SQL

Hi everyone,

I have a package like this:

CREATE OR REPLACE PACKAGE test IS

TYPE cur_type IS REF CURSOR;

TYPE cur_Analysis IS RECORD (
ANALYSIS_ID number,
ORDER varchar2);

TYPE cur_typeAnalysis IS REF CURSOR RETURN cur_Analysis;

PROCEDURE p_Report (i_v_Name IN varchar2
,i_v_Owner IN varchar2
,i_cur_Analysis IN cur_typeAnalysis
,i_cur_Schedulers IN cur_type
,o_n_ERROR_CODE OUT NUMBER
,o_v_ERROR_TEXT OUT VARCHAR2);
END test;

The problem is that sometimes the procedure p_Report gets i_cur_Analysis and i_cur_Schedulers equal to null. Because of that I get an error message like this: PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter.

Can anyone give me some help on this?

Thanks,
Maria