jobs wrote:
> 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.
Not an uncommon issue but one Oracle handles easily if you use the
UTL_URL built-in package. http://www.psoug.org/reference/utl_url.html
--
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 - 20:23:25 CDT