ORA-44003: invalid SQL name when inserting data
I had this application in APEX 3.1 nothing fancy, just a form that inserted data in a table (plus other regions for other features).
It used to work just fine in 3.1, I migrated it to APEX 4.0 and now with no changes to the form some of them are failing with this error:
ORA-44003: invalid SQL name
In the past I have fixed it by recreating the form. I would like to be able to fix this error now without recreating this form as I have other regions and it would take me some time to recreate it.
does anyone has experienced a similar error or have any clues how to fix it ?
If not, does anybody has clues how to debug it to see what the problem is? I found this note about this error: http://www.oracle-base.com/articles/10g/dbms_assert_10gR2.php , so how do I know the SQL name syntax used by APEX ?
Thanks in advance