How to post data using URL from plsql

Hi,

Below is the service in which I want to access the post method from plsql.

https://apex.oraclecorp.com/pls/apex/training_app_dev/seaashm/keyevent

the service does have four parameters. How do I call the service from plsql passing all the parameters.
sakthikumarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
girionisCommented:
You need to use UTL_HTTP:

      req   UTL_HTTP.REQ;
      resp  UTL_HTTP.RESP;

Open in new window


then create your post body:

postBody := 'parama='|| parama ||'&paramb='|| paramb ||'&paramc='||paramc || '&paramd=' || paramd;

Open in new window


Once you have your postBody you can do:

req := utl_http.begin_request('https://apex.oraclecorp.com/pls/apex/training_app_dev/seaashm/keyevent', 'POST',' HTTP/1.1');
 utl_http.set_header(req, 'user-agent', 'mozilla/4.0'); 
utl_http.set_header(req, 'content-type', 'application/x-www-form-urlencoded'); 
utl_http.set_header(req, 'Content-Length', length(postBody));
          
utl_http.write_text(req, postBody);

resp := utl_http.get_response(req);

            begin
                loop
                    utl_http.read_line(resp, buffer);
                end loop;
               utl_http.end_response(resp);
                exception
                when utl_http.end_of_body then
                    utl_http.end_response(resp);
                end;

Open in new window

0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
girionisCommented:
I gave a perfectly correct answer, so I object to the deletion of this question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.