Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

intermittently getting ORA-29261: bad argument

2905573Mar 30 2017 — edited Apr 4 2017

intermittently getting ORA-29261: bad argument.

UTL_HTTP.set_response_error_check (ENABLE => TRUE );

  UTL_HTTP.set_detailed_excp_support (ENABLE => TRUE );

  l_pass :=de_crypt('PWD','KEY');

  UTL_HTTP.set_wallet(XXXXXXX, XXXXXX);

  http_req      := Utl_Http.begin_request (url => l_buynet_url,method => 'POST',http_version => 'HTTP/1.0');

  IF l_time_out IS NOT NULL THEN

    utl_http.set_transfer_timeout(http_req,l_time_out);

  END IF;

  UTL_HTTP.set_header(http_req,'Content-Type','text/xml');

  UTL_HTTP.set_header(http_req,'Content-Length', LENGTH(l_request));

  UTL_HTTP.WRITE_TEXT (r => http_req,data => l_request);

  http_resp := UTL_HTTP.get_response(http_req);

  BEGIN

    LOOP

      UTL_HTTP.read_text ( r => http_resp, data => v_buffer);

      l_resp := l_resp || v_buffer;

    END LOOP;

  --utl_http.end_response(http_resp);

  EXCEPTION

  WHEN UTL_HTTP.end_of_body THEN

    NULL;

  END;

We get Error in between only, Wallet is set, Certificate are placed. But in between get the error.

Any Thoughts ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2017
Added on Mar 30 2017
4 comments
5,586 views