Oracle APEX takes a value from a function and uses it to open a new page
I have a function that returns a value (e.g.27). I am put this value to my page item (P2120_SYMPTOM_ID) and i want with this value to open with button another page (P2140).
I am going to button Link builder - target and i am using P2120_SYMPTOM_ID like this:
but unfortunatendly this value doesn't pass to my new page criteria. How can i use this value?
Solution
If you're just navigating to another page (as opposed to opening a modal window) then use action "Submit" on your button and create a branch to the new page. That is how navigation is supposed to be done. The link builder links are generated when the page is rendered and do not pick up session values.
- Transpose Hierarchical Table based on leaf nodes with nodes as first column
- Comparisons using EXTRACT YEAR not working
- Oracle Analytics - partitions and ordering of sql queries
- Selecting a sequence NEXTVAL for multiple rows
- Oracle procedure error: Expected UDT got CHAR
- Transform Travel Table - SQL
- Get lowercase letters from Oracle 10g columns
- pull access denied for container-registry.oracle.com/database/enterprise
- USE database_name command alternative for Oracle
- How to return columns from dynamic SQL in Python console
- How to determine if and which index is being used in oracle
- How to raise Oracle PL/SQL exceptions from Python
- sql extraction of identification numbers
- Oracle Database: Find Missing Indexes for Performance tuning
- difference between 'natural full outer join' and 'full outer join'
- SQL query giving error msg not enough values
- Unique Constraint violation
- Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-00302: component 'GET_EMP_INFO' must be declared"
- ORA-00001: uniqueness constraint violated
- Unable to set CLASSPATH with confluent CLI : java.sql.SQLException: No suitable driver found for jdbc:oracle:thin
- In an oracle RAC setup, can a single transaction be assured to be executed on a single node?
- Django: how to see the SQL query when running tests?
- Multiple Passwords for Multiple Schemas in single connection
- Get the resultset of any SQL cursor as XML with column names as attribute without using XSLT in Oracle
- Get UDT type name inside of its body in Oracle 19c
- Oracle regexp_replace
- Extracting data from an Oracle DB on python. Facing issues with the multibyte characters
- Setting report column to YES or NO based on date - Oracle SQL
- SQL script called from Jenkins Pipeline does not output error or correct exit code
- Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field