Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-20512: Invalid action CREATE on this object. (UD)???

724687Nov 26 2010 — edited Dec 12 2010
Actually, 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2011
Added on Nov 26 2010
5 comments
1,932 views