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!

Ajax Callback - Parameters

partlycloudyOct 15 2018 — edited Oct 15 2018

apex.server.process can be invoked from client-side Javascript to read/write data on the server. The pName parameter to this API is The name of the PL/SQL on-demand page or application process to call. Parameters to this process are passed using the apex_application.g_xNN package variables. This process typically returns a JSON object back to the client. For DML operations, this is typically a simple success/failure code/message. When data needs to be retrieved, it tends to be a more complex object. Putting all this code in the APEX application/page process (AJAX callback) is considered poor practice.

I guess the only option is to create a packaged or standalone stored procedure and use that as the application/page process with the restriction that it should have exactly zero parameters, instead all IN and OUT parameters are passed using APEX session state/package variables.

Something like this.

pastedImage_10.png

Am I on the right track?

This post has been answered by Pierre Yotti on Oct 15 2018
Jump to Answer
Comments
Post Details
Added on Oct 15 2018
3 comments
9,797 views