I have two separate SQL Reports which usually run OK, but which sometimes report 'ORA-01741 Illegal zero-length identifier'. Once the error shows up, it persists, but usually logging out of apex and back in will clear it.
The reports are similar. There is a parameter page where the user selects a date from a popup lov and presses a button which runs the report. The reports refer back to the lov item as a bind variable
where invoice_date
between :p17_start_date and add_months(:p17_start_date,1)-1
where the report is actually on page 18.
I've found various references to ora-01741 in the forum, but they all seem to be persistent errors, what makes this difficult to track down is that it is intermittent.
What could cause this? A null bind variable? An odd value in a bind variable?
I'm suspecting a specific path through the application which leaves something in an unusual state but I don't know what.
I'm using
Apex 3.2.1.00.12
RDBMS 9.2.0.8