Error ORA-20512: Invalid action CREATE on this object. (UD)???
724687Nov 26 2010 — edited Dec 12 2010Actually, I have two questions:
1.
I can't figure out why I have this error. I have a simple interactive report with form. On this form are 3 fields (a hidden ID field, a message_code field and a message_text field). I have a custom stored procedure to insert a message in the message table. I made a PL/SQL block for this in the page processes and made it conditional when the create button is pressed (process is the first page process). I unchecked the "insert" from Allowed Options in the ARP(DML) process, since I like to use it for the update and delete actions. The stored procedure is actually called, because when I input invalid data (exisiting error code, for example) the custom raise_application_error from the stored procedure is shown in Apex, as it should be.
What could be the problem here?
2.
Actually, what is the function of the "Allowed Operations" option in a DML process? What actually changes when checking or unchecking operations there? If I uncheck the "delete option", I would expect the delete button to dissapear, or at least the delete option would not work anymore, but this is not the case. Even when I uncheck "delete", I can still us the delete button and it still deletes the record. What use is this option then?