Here are the steps for designing a success message that shows the column value in APEX:
DECLARE lcolumnvalue VARCHAR2(100); BEGIN SELECT columnname INTO lcolumnvalue FROM tablename WHERE condition;
APEXUTIL.SETSESSIONSTATE('P1SUCCESSMESSAGE', 'The column value is ' || lcolumn_value); END;
This code selects the column value from a table based on a condition and assigns it to a variable called "lcolumnvalue". Then it sets the session state of a page item named "P1SUCCESSMESSAGE" to a success message that includes the column value.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2021-05-31 11:00:00 +0000
Seen: 12 times
Last updated: Aug 16 '21
What is the process for transforming a CURL command into PL/SQL?
How can operations be performed on the return value of a function in Oracle PLSQL?
How can the closure of a sysrefcursor that is returned from a Plsql Stored Procedure be managed?
How can column names be set in Oracle PL/SQL by referring to another table?
How can null columns be dynamically generated in PL/SQL?
How to open a new tab when using OWA_UTIL.REDIRECT_URL in PL/SQL?
How can the issue of receiving an empty return from Json parse in plsql be restated?
What is the time-consuming process of creating a CSV containing 200,000 lines using Oracle PL/SQL?