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!

Apex 21.1: Form page - how to have application item value in primary key page item

SmithJohn45Nov 22 2021 — edited Nov 22 2021

created a Form type page ( here i will create more regions ) which will show user data after login, like a user profile and it can be editable, also add/update profile picture.
i tried to add a process before header to assign value as :P24_ID := :SESSION_USER_ID (after successful login, SESSION_USER_ID have user's ID column value for later use), when run this page apex showing error page here it says: ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error
image.png
i set default value for P24_ID, type: Item and Item=SESSION_USER_ID then nothing appear in Form.
how i can have the login user's value and allow update only.
regards

Comments
Post Details
Added on Nov 22 2021
4 comments
645 views