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!

Inserting User (APP_USER) on table from DML Form

SoraiaOct 22 2018 — edited Oct 22 2018

Hello.

I'm new on Apex! Using 4.2

I am triyng to use a DML Form to insert a row on a table and Cusername is mandatory and should be the user loged in the application.

The item P13_CUSERNAME shows in the form the correct user having the source as a PL/SQL Expression: V('APP_USER').

But when I press theh create button which has a action of submit page, database action: SQL INSERT action, I.m getting the error

  • ORA-01400: cannot insert NULL into ("LSPROD"."JAUSR"."CUSERNAME")

What should I do to populate the column on insert? Dynamic action? Process?

Thank you

S

Comments
Post Details
Added on Oct 22 2018
2 comments
1,495 views