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: jobs <jobs_at_webdos.com>
Date: Tue, 21 Aug 2007 15:30:01 -0700
Message-ID: <1187735401.935336.304010@m37g2000prh.googlegroups.com>


On Aug 21, 5:06 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

Sorry I tried to delete original post.. which apparently never works.

My issue was spaces in my url which I fixed.

9i btw.

thanks anyways. Received on Tue Aug 21 2007 - 17:30:01 CDT

Original text of this message

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