APEX

I have a procedure with 133 parameters. Since OAE can only render 100 fields at most, I've made multiple pages to submit the same stored procedure, with certain subsets of the fields on each page, and the others null.

But I cannot seem to pass NULL values to the stored procedure.

I tried calling it with NULL eg,

package.procedure(:item1,:item2,NULL)

I got an error, so I made a text field on the screen called P102_NULL, and now have:

package.procedure(:item1,:item2,:P102_NULL)

It keeps giving this error: Error ERR-1002 Unable to find item ID for item "" in application "109".

I've tried making the P102_NULL field hidden, display only but submit, normal text field etc.
I tried using V('P102_NULL') instead of :P102_NULL but it doesn't seem to matter.