This discussion is archived
1 Reply Latest reply: Jul 31, 2013 8:49 AM by jstraub RSS

Using DADs in APEX in Oracle Database Cloud

user603925 Newbie
Currently Being Moderated

Hi,

 

How is it possible to call procedures via DAD like the following?

https://database-trialaxyz.db.us1.oraclecloudapps.com/apex/XYZSCHEMA.xyz_package.xyz_proc?p_param1=123&p_param2=999

Hence request path contains the procedure call.

 

Thanks a lot for your advice.

Karin

  • 1. Re: Using DADs in APEX in Oracle Database Cloud
    jstraub Journeyer
    Currently Being Moderated

    Karin,

     

    That is not possible on the database cloud. Your procedure would have to be authorized to be called (which it won't be on the cloud) and your procedure would need to be able to be publicly executable, which also is not allowed on the cloud.

     

    What you could do is create a RESTful service in SQL workshop that would accept your desired parameters, and then turn around and invoke the procedure using those parameters.

     

    Regards,

     

    Jason

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points