Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
ORDS, SODA & JSON in the Database
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 15, 2013 12:16 PM by
How to use PL/SQL procedure/function in Resource Template (listener 1.1.3)?
Feb 15, 2013 12:16 PM
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
This content has been marked as final.
Show 0 replies