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

guyenko:

Update: Clearly, I'm an idiot. After posting, I tested my assumption--rather than before.

Print out the value of $sendthis after your assignment--it doesn't contain what you think it does.

my $sendthis = ('<?xml version="1.0" enconding="utf-8"?>
<students>
<row>
       <name>Mark</name>
      <age>30</age>
</row>
</students>');

[download]

I don't think you really want to send the value '1', do you? (I fixed the typo at the end of that statement.)

...roboticus

When your only tool is a hammer, all problems look like your thumb.

  • Comment on Re: 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^2: Http Post to Oracle Apex restful web service inserts null into oracle database table with XMLType and varchar2 columns
by guyenko (Initiate) on Oct 18, 2013 at 19:06 UTC

    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

    [download]
    I am very new to Perl and web services. Thank you!

[reply]
[d/l]

      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?

[reply]

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

[reply]

In Section Seekers of Perl Wisdom