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!

HTTP protocol error

ora_1978Feb 19 2014 — edited Feb 20 2014

what is the cause of this error and how to reswolve it.

SQL> declare

  2   req       UTL_HTTP.REQ;

  3   resp      UTL_HTTP.RESP;

  4  begin

  5  UTL_HTTP.set_wallet('file:/usr/oracle/exports/exp001/certification', 'india_tax');

  6  req := UTL_HTTP.BEGIN_REQUEST (url=>'https://wwwqa.taxengine.ford.com', method=>'POST');

  7  UTL_HTTP.SET_HEADER (r      =>  req,

  8                       name   =>  'Content-Type',  

  9                       value  =>  'text/xml');

10  UTL_HTTP.SET_HEADER (r      =>   req,

11                       name   =>   'Content-Length',

12                       value  => '1024');

13  UTL_HTTP.WRITE_TEXT (r      =>   req,

14                       data   =>   'username=rvinodh3&passwd=qazmko1$');

15  resp := UTL_HTTP.GET_RESPONSE

16                       (r     =>   req);

17 

18  end;

19  /

Enter value for passwd: qazmko1$

old  14:                      data   =>   'username=rvinodh3&passwd=qazmko1$');

new  14:                      data   =>   'username=rvinodh3qazmko1$=qazmko1$');

declare

*

ERROR at line 1:

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1369

ORA-29263: HTTP protocol error

ORA-06512: at line 15

Vinodh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2014
Added on Feb 19 2014
4 comments
3,662 views