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!

Passing Json payload through PL/SQL procedure using Rest data source to a Oauth enabled endpoint in OIC.

Prachi MehtaJul 24 2024

Hi, I need to send Json data to OAuth enabled endpoint in OIC. I have created web credentials in Apex for that endpoint and using those web credentials i have created a rest data source. Now i am using this PL/SQL code to invoke the endpoint through rest data source.

Declare

l_context apex_exec.t_context;

Begin

apex_session.create_session(p_app_id =>'app id' , p_page_id => ‘page of application’, p_username =>'user');

END;

BEGIN

---CAll the rest data source using APEX_EXEC---

l_context := APEX_EXEC.OPEN_REST_SOURCE_QUERY(

p_static_id => ‘oic_rest’

);

END;

END;

Now this procedure is working fine and sending the json data which i have given in the POST operation while creating the rest data source. But i want to pass the json payload through the procedure. How can implement that in my procedure.

This post has been answered by Carsten Czarski-Oracle on Jul 30 2024
Jump to Answer
Comments
Post Details
Added on Jul 24 2024
4 comments
1,456 views