I cannot figure out how to define a test where I need to pass a table of records to a stored procedure. When I generate and compile the test code, the named parameter in my store procedure is assigned a NULL value, instead of the collection I have defined, like so:
q##start_time := DBMS_UTILITY.get_time; super_test_cp.ins (**rows_in => NULL**, handle_error_in => TRUE); -- Capture post-execution values. q##sql_rowcount := SQL%ROWCOUNT;
The variable name automatically available in Step 2 of the Test Case Editor (i_ROWS_IN in my case) does not seem to be used in the call to the stored procedure. I can add initialization code to fill the collection with data, but it is never passed to the procedure and I get a compile time error (cannot pass NULL to a NOT NULL constrained formal parameter).
It feels like I’m missing something obvious here, but I can’t figure out what it is .