title: Oracle ORDS remote procedure call : payload and debug
body: <p>I am trying to develop some REST API and I am working with: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Oracle ORDS and SQL Developer 17.3.1.279.</p>
  <p>I already develop and test a GET API in order to prove that the db is REST-Enabled.</p>
  <p>I try to develop a POST API and I am reading <a href="https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-remote-procedure-call-rpc-and-output-parameters" rel="nofollow noreferrer">this article</a></p>
  <p>My POST handler is :</p>
  <pre><code>declare
      lrow accounts%rowtype := null;    
  begin   
      lrow.id := :id;
      lrow.account := :account;
  
      /*added to inspect the current value*/
      Raise_Application_Error(-20000, '*'||:account||'*');
  
      lrow.category := :category;
      lrow.address := :address;
      lrow.zipcode := :zipcode;
      lrow.city := :city;
      lrow.county := :county;
      ASADMIN.INSERTACCOUNT(lrow);
      :error := null;
  exception
      when others then
          :error := sqlerrm;
  end;
  </code></pre>
  <p>For each bind variable I create a corresponding in/out parameter in the handler.</p>
  <p>I test the API with POSTMAN passing this object:</p>
  <pre><code>{
  &quot;id&quot; : &quot;18092018&quot;
  ,&quot;account&quot; : &quot;Buster Keaton&quot;
  ,&quot;category&quot; : &quot;TEST CATEGORY&quot;
  ,&quot;address&quot; : &quot;TEST ADDRESS&quot;
  ,&quot;zipcode&quot; : &quot;12345&quot;
  ,&quot;city&quot; : &quot;TEST CITY&quot;
  ,&quot;county&quot; : &quot;TEST COUNTY&quot;
  ,&quot;error&quot; : null
  }
  </code></pre>
  <p>and the response was &quot;Cannot insert NULL in ...&quot; then I add the raise application error in order to check what is the value passed that results as null.</p>
  <p>I would like to know wich is the common (or best) preactice to debug a REST API and the way to &quot;monitor&quot; bind variables.</p>