oracleoracle-apexoracle-apex-5.1oracle-apex-5
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.
- Create date periods based on two tables
- Missing expression in Oracle Function
- Examine all REF CURSOR outputs from stored procedure called in a loop
- PLS-00382: "expression is of wrong type" when opening REF CURSOR on stored procedure called in a loop
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PowerShell Script Failing at insert records
- How to resolve the following AWS Glue error while writing to Redshift using Spark: "ORA-01722: invalid number"?
- How to create an oracle.sql.ARRAY object?
- Select rows with same item code but different value in another column
- SQL select distinct with condition
- How to pretty format the printing of SQL queries in SQLAlchemy
- JetBrains PhpStorm / DataGrip introspecting Oracle database error
- Is there any way to maintain large scale data rules efficiently in SQL?
- How to check if input parameter of timestamp type in oracle stored procedure is null?
- How can I number the instance of a duplicate record?
- How to convert oracle regex pattern into Databricks compatible version?
- oracle add_months function differs from Java
- How to export (expdp) a tablespace Oracle express 21c?
- How to query the distribution (grouped by value range) of a column value in Oracle?
- Avoid ZERO and NULL Record
- BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page
- ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 82: ORA-00936: missing expression
- django how to see sql query when running tests?
- How to identify rows that add up (sum) to a specific amount
- oracle sql developer - HOW TO put together the results of 2 selects that have nothing in common
- No more data to read from socket error
- How Grant Create Foreign Key on another schema?
- Call a function in SQL Server and Oracle with same syntax
- Py2exe with cx_oracle. Exe won't run on other computers
- Oracle data types: advice on choosing NUMBER versus BINARY DOUBLE?