in reply to Re: Http Post to Oracle Apex restful web service inserts null into oracle database table with XMLType and varchar2 columns
in thread Http Post to Oracle Apex restful web service inserts null into oracle database table with XMLType and varchar2 columns

Thank you for your help! I am trying to replicate the following http post request found here

http://xmodulo.com/2013/05/how-to-send-http-get-or-post-request-in-perl.html

I would like to pass XML data into the database through an Oracle APEX restful service. I continue to insert a null value into the database. Here is the only anomaly I see after the script is executed:

LPW::UserAgent::_need_proxy: Not proxied
I am very new to Perl and web services. Thank you!

  • Comment on Re^2: Http Post to Oracle Apex restful web service inserts null into oracle database table with XMLType and varchar2 columns
  • Download Code

Replies are listed 'Best First'.
Re^3: Http Post to Oracle Apex restful web service inserts null into oracle database table with XMLType and varchar2 columns
by Anonymous Monk on Oct 19, 2013 at 07:13 UTC

    I am trying to replicate the following http post request found here

    Well, you say that part is successfull ; sure, you posted code full of syntax errors which wouldn't run, but if your real code is inserting nulls it means it runs, which means the "post"ing part works

    What must be the problem is what you're posting, not how

    So what APEX docs are you reading that tell you what you're supposed to send?

      Unfortunately, Oracle provides mediocre documentation on POST APEX Restful web services. I will ask Oracle support for more info. Thank you for your help!