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!

APEX_PAGE.GET_URL using p_plain_url='TRUE' => ORA-06553

Birthe GebhardtJan 15 2021 — edited Jan 15 2021

Hello,
I need to get the URL from an modal Dialog (without javascript around).
System: Oracle ATP
Oracle APEX 20.2
Database: 19c
Query:
SELECT APEX_PAGE.GET_URL (p_application => 142,
p_page => 15,
p_items => 'P0_PJ_ID,P0_PS_ID',
p_values => (42 || ',' || 326),
p_plain_url => 'TRUE')
FROM dual;
Result:
ORA-06553: PLS-306: Falsche Anzahl oder Typen von Argumenten in Aufruf von 'GET_URL'
06553. 00000 - "PLS-%s: %s"
*Cause:
*Action:

If I remove the parameter p_plain_url then it works.

Any hints are welcome.

Thanks,
Birthe

Comments
Post Details
Added on Jan 15 2021
4 comments
12,794 views