Skip to Main Content
Forums

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!

Apex 4.2 and Database trigger issue:APEX_PUBLIC_USER instead of APEX user

Sergio VegaOct 5 2015 — edited Oct 5 2015

I have an application in Apex 4.2 that contains a page with a form to submit data to a table. This table has a trigger "BEFORE INSERT OR UPDATE ON MY_TABLE FOR EACH ROW" used to get user and date.

Now, for each record I add using that page and form the trigger is saving into :NEW.user_ins this value "APEX_PUBLIC_USER".

IF INSERTING THEN

:NEW.dt\_ins   := SYSDATE;

IF :NEW.user\_ins IS NULL THEN

 :NEW.user\_ins := nvl(wwv\_flow.g\_user,user);

END IF;

END IF;

Page is not public so I think there's not reason to use that value.

2015-10-05_10-17-31.png

Does anyone know the reason of this?

Sergio

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2015
Added on Oct 5 2015
#apex-discussions, #trigger
6 comments
466 views