UTL_HTTP and Cookies

I'm using version 9.2.0.1.0 of Oracle RDMS.

   Can someone tell me if Oracle UTL_HTTP can retrieve cookies sent back from HTTP Requests.

I've built a PL/SQL package with common logic for sending requests and receiving responses from a webserver application. The requests are successful and I do get responses from the server in XML.

  The problem is that the Webserver app sends a cookie with some information that my packages needs to retrieve and send back with subsequent requests for the session.

  I'm enabling cookie support after the forst call to utl_http.begin_request(..) and after I call utl_http.get_response and call utl_http.get_cookies(cookie_table), the table is always empty. For a while this led me to believe that the web app was not sending cookies. So I wrote small java program to send a request and retieve the cookies and sure enough the cookies are present in the response. I used TCPMON to capture the XML transations being sent and the cookie is in the stream.

  Has anyone gotten cookie support in UTL_HTTP support?

   I have cookie support enabled, but when I send the requests and get a response back, the cookie table is always empty. The text in the reponse is as expected as well as the response header info.

   I wrote a small java program to send the same requests to the servlet and display the headers. The servlet is indeed sending cookie information.

Thanks in advance
Gerald Received on Wed May 04 2005 - 11:30:30 CDT