Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: utl_http.request <h1>Bad Request</h1>

Re: utl_http.request <h1>Bad Request</h1>

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Aug 2007 14:06:55 -0700
Message-ID: <1187730414.654711@bubbleator.drizzle.com>


jobs wrote:
> I have other asp.net web services that I can call with no problem from
> oracle as follows:
>
>
> declare
> o varchar2(5000);
> i varchar2(256);
> begin
> i := 'http://xxx/xxx/xxx/etFullName?userName=' || 'company\myname';
> o := utl_http.request(i);
> dbms_output.put_line(o);
> end;
>
> However, I have a web service(with many more parms) that I can call
> from IE with no problem, but If I call it in the same way (above)
> from oracle I get:
>
> <h1>Bad Request</h1>
>
> The exact string its attempting to pass to utl_http.request works fine
> from IE.

What version?
Without seeing the actual string it is impossible to advise but <h1>Bad Request</h1> is not an Oracle error message. Try it in SQL*Plus and find out what is actually happening.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 21 2007 - 16:06:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US