Skip to Main Content

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!

How to Retrieve URL Parameter's Value?

DannyS-OracleJul 7 2016 — edited Jul 8 2016

Hi all, I hope someone can help me on this simple problem. I would like to create a simple page which will retrieve a value from another page via URL. So far I have no luck to retrieve it.

So on my first page, I have a report with the ID column's type set to link. If clicked, the app will redirect to the second page by passing the ID's value:

Screen Shot 2016-07-07 at 7.07.29 PM.png

The value is passed in the URL (e.g. https://apex.oraclecorp.com/pls/apex/f?p=29971:3:6650060513775::NO:RP:Account_ID:1), but I could not retrieve it when I tried to build a classic report via SQL:

SELECT

\*

FROM

AccountSupport\_Account a

WHERE

a.ID = :Account\_ID

Whenever I click the link to that page, it always throw error: Unable to find item ID for item "ACCOUNT_ID" in application

Any help will be appreciated! I am using Apex 5.0 btw.

This post has been answered by Scott Wesley on Jul 7 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2016
Added on Jul 7 2016
4 comments
537 views