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!

PLS-00201: identifier 'GET_STATUS' must be declared

adnan645Apr 12 2020 — edited Apr 12 2020

Hi,

I am trying to set a default value for a field on the form when it is submitted.

List of Values are IDs (1, 2, 3) in that field. In a table these IDs 1, 2, 3 have names as OPEN, CLOSED, PENDING, respectively. Now I put PL/SQL Function body command as RETURN get_status('OPEN'); but I am getting below error:

ORA-06550 line 1, column 140: PLS-00201: identifier 'GET_STATUS' must be declared

Below is also the screenshot.

pastedImage_0.png

Regards,

Adnan Arshad.
This post has been answered by jariola on Apr 12 2020
Jump to Answer
Comments
Post Details
Added on Apr 12 2020
#apex-discussions
3 comments
264 views