Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
APEX- Passing the values of the page item from my page 1 on submit and using a procedure to display

In page 1 I have a region which has many page items. On entering the values in these page items and on click of submit, I need to get redirected to page 2 and display all the values on the page(Please note that I will not be having any page items in the page2) How can I use a procedure in page 2 and get all the values from page1. PS: My region is as below.
And my expected output is
Best Answer
-
I wanted to pass all the values from the page 1 and get the values in page 2, so that it can be used with the static content.
Strictly speaking if the intention is to pass values between pages then corresponding items would have to exist on each page.
However, since the APEX session state namespace is global, item values can be referenced on other pages. In static content this is done using static text substitution strings of the form
&PX_ITEM_NAME.
:My release dependency is &P1_RELEASE_DEPENDENCY.. The version is &P1_VERSION_DEPENDENCY. created on &P1_CREATION_DATE. &P1_LONG_DESCRIPTION.
This approach is not as safe as passing the values into dedicated items on page 2: the values on page 1 could be changed or cleared elsewhere in the application, leading to issues if the user views page 2 without realising this has occurred.
When values are required globally or on multiple pages it is advisable to use Application Items.
Answers
-
Please update your community profile with a recognisable username instead of "User_OG2E4".
In page 1 I have a region which has many page items. On entering the values in these page items and on click of submit
What processing occurs on submission of page 1?
What are the page modes of pages 1 and 2?
-
There is no page processing.. Its a normal page with regions and user inputs the details in these region and on submit a branch is created which gets redirected to the 2nd page(Normal Blank page). I wanted to pass all the values from the page 1 and get the values in page 2, so that it can be used with the static content.
- What should be my approach to get all the values from page 1?(PS: The passed values can be very long as well) The static content will be something like below.
- Should i use a procedure or a html code to get this type of static content.
I am new to apex , kindly advise.
<<Static content>>
--------------------------------------------------------------------------------
-- Delivery Date:
define delivery_date = '08.07.2022'
--------------------------------------------------------------------------
-- Dependent release: (last release needed as precursor)
define release_dependency = 22.302
--------------------------------------------------------------------------------
-- Dependencies: (needed last succesfully run script-version)
define version_dependency = '0'
--------------------------------------------------------------------------------
Regards,
Nikki
-
I wanted to pass all the values from the page 1 and get the values in page 2, so that it can be used with the static content.
Strictly speaking if the intention is to pass values between pages then corresponding items would have to exist on each page.
However, since the APEX session state namespace is global, item values can be referenced on other pages. In static content this is done using static text substitution strings of the form
&PX_ITEM_NAME.
:My release dependency is &P1_RELEASE_DEPENDENCY.. The version is &P1_VERSION_DEPENDENCY. created on &P1_CREATION_DATE. &P1_LONG_DESCRIPTION.
This approach is not as safe as passing the values into dedicated items on page 2: the values on page 1 could be changed or cleared elsewhere in the application, leading to issues if the user views page 2 without realising this has occurred.
When values are required globally or on multiple pages it is advisable to use Application Items.