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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SYS_GUID not being inserted in PLSQL Expression

User_RZ2O1Aug 11 2021

Hello,
I have a form in my application to add a row into a lookup table. This is the insert statement contained in the dynamic action that executes a server-side code.
INSERT INTO NON_APPLICATION_ACTIVITY (NON_APPLICATION_ACTIVITY_ID, ACTIVITY_EN_NAME,
ACTIVITY_FR_NAME, ACTIVE_IND, EXPIRY_DATE, EFFECTIVE_DATE, LAST_MODIFIED_DATE, LAST_MODIFIED_USER)
VALUES ((SELECT SYS_GUID() FROM DUAL), :P13_ACTIVITY_EN_NAME, :P13_ACTIVITY_FR_NAME, 1, sysdate, sysdate, sysdate,(SELECT USERNAME
FROM PERSON
WHERE (SELECT NVL ((UPPER (APEX_UTIL.get_username (APEX_UTIL.get_current_user_id))), USER)
FROM SYS.DUAL) = UPPER(USERNAME) ) );
When I click on the button to execute this code, it says it can't insert null into NON_APPLICATION_ACTIVITY_ID. Does anyone know why the statement 'SELECT SYS_GUID() FROM DUAL' would return null in APEX? This work just using PL/SQL Developer.

Comments

Post Details

Added on Aug 11 2021
0 comments
236 views