Hi. Any help/insight on my problem would be greatly appreciated - as I am at a totally loss. We have implemented the following code:

CREATE OR REPLACE PROCEDURE TEST IS

http_req utl_http.req;
http_resp utl_http.resp;
request_env varchar2(32767);
response_env varchar2(32767);
l_xml_test varchar2(32767);

begin

l_xml_test := '<ImportInfo
<DetailInfo>
<Wildcarddata>
<General.Field01>WC Value1</General.Field01>
<General.Field02>WC Value2</General.Field02>
<General.Field03>WC Value3</General.Field03>
<General.Field04>WC Value4</General.Field04>
</Wildcarddata>
</DetailInfo>
</ImpoInfo>';


request_env :='
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ImportCode xmlns="http://tempuri.org/">
<xmlClaimData>'||l_xml_test||'</xmlClaimData>
</ImportCode>
</soap:Body>
</soap:Envelope>';

Utl_Http.Set_Response_Error_Check ( enable => true );
Utl_Http.Set_Detailed_Excp_Support ( enable => true );



http_req := utl_http.begin_request('http://ipaddress/service name', 'POST', utl_http.HTTP_VERSION_1_1);

--utl_http.set_authentication (http_req, username, password,'Basic', false);

utl_http.set_header(http_req, 'Content-Type', 'text/xml; charset=utf-8');
utl_http.set_header(http_req, 'Content-Length', length(request_env));
utl_http.set_header(http_req, 'SOAPAction', '"http://tempuri.org/ImportCode"');
utl_http.write_text(http_req, request_env);


http_resp := utl_http.get_response(http_req);
dbms_output.put_line('resp:--' || http_resp.status_code);

utl_http.read_text(http_resp, response_env);

utl_http.end_response(http_resp);
DBMS_OUTPUT.PUT_lINE(RESPONSE_ENV);
EXCEPTION


WHEN OTHERS THEN
dbms_output.put_line('err->' || sqlerrm);
end;


which works great if we comment out the line:

--utl_http.set_authentication (http_req, username, password,'Basic', false);

and access the web service that does not require authentication against AD. As soon as the web service requires authentication and we add back the set_authentication code we get the following error:



ORA-29269: HTTP server error 500 - Internal Server Error

Does anyone know if there needs to be any special configuration on the oracle server and/or I am required to use an Oracle wallet.

We are run oracle 10g on a Unix server.



Debby