I am getting the following Error: ORA-44003: invalid SQL name...
And yes I red the posts regarding this topic. I am not asking what caused this error but I would like to now if somebody can tell me if it is possible to view the INSERT Statement generated by an DML FORM.
By the way I am using Apex 4.0.2.00.07
Thanks in advance...
To my knowledge the insert statement itself is not directly visible. What you can try is create an new application with only one page and one form, export the application and look at the code of your export file. There you should be able to see what procedures and functions are used for your form. Mostly these functions are part of the apex_util package, you can have a look at the package specifaction and see if you can get any info out of it. The body of the package is wrapped, so yuo need to use an unwrapper to view that.
You put the page in DEBUG mode. (ie click the DEBUG button on the bottom)
Run the page
Then you click the "View DEBUG".
That will pop-up a window with a Report of recent page runs (that were ran in DEBUG mode) for your session. (filters are automatically added)
Within the details, you will see A LOT of information.
This is where you view everything about the back-end processing of an APEX page.
This is also where you see all the output from your custom PL/SQL code when you use the APEX_DEBUG utility.
I suggest you look at that page very closely so you know what type of information shows up there.
At some point in time, you'll need to know what the server is thinking to figure out why something didn't do what you thought it should do.
To find the INSERT statement, you'll have to look through that large report.
The easiest way is just to search for the word INSERT
thank you, your answer was really helpful. I found out that the value for my primary key wasn't stored in the corresponding item, i fixed that problem by changing the item from hidden to read only( it seems a known problem that you cant store values in hidden items ).
The problem with the information shown on the "View Debug" page is, that it is not complete, so the important parts needed for my analysis is not shown. But if i am querying the "apex_debug_messages" view I obtain the session id in which the sql statement was executed.
Now I am searching for a view or table inside the oracle db, where executed sql statements are stored (temporarly) and try to find the statement over the session id... I let you know when i have some results.
Cheers and thanks again