utl_http and Oracle RTC xsd calls
Hi,
I am trying really hard to schedule, delete, etc. appointments from PL/SQL in the Collaboration Suite's Web Conferencing using Oracle RTC xsd/xml calls. I am getting really close. I know that my url to delete the conference works by pasting it into a browser. I am getting response xml as well. I just can't get to the bottom of this cookie/authenication stuff. I have seen examples to view and reload the cookies but not creating one. Anyway, I am asking for a little help. Attached is a copy of my stored procedure and the output. Thanks for your help, Liz
PROCEDURE HTTP_TEST IS
req utl_http.req;
resp utl_http.resp;
name VARCHAR2(256);
value VARCHAR2(32000);
i integer;
BEGIN
req := utl_http.begin_request('http://10.10.11.246:7778/imtapp/OracleRTCService?operation=deleteMeeting&xmlin=<request><meetingid>10142</meetingid><siteid>101</siteid></request>');
utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0');
utl_http.set_header(req, 'siteauthkey', 'MTAxOkNDRjZBRTBCRUY');
utl_http.set_header(req, 'user', 'lizp');
utl_http.set_header(req, 'password', 'cup123');
resp := utl_http.get_response(req);
LOOP
utl_http.read_line(resp, value, TRUE);
i := 1;
while i < length(value) loop
dbms_output.put_line(substr(value,i,i+254));
i := i + 255;
end loop;
END LOOP;
utl_http.end_response(resp);
EXCEPTION
WHEN utl_http.end_of_body THEN
utl_http.end_response(resp);
END;
SQL> execute conf_integration.http_test;
<?xml version="1.0" encoding="UTF-8"?><response
xmlns="http://www.oracle.com/xml/API"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.oracle.com/xml/API
http://titan.ehsmed.com:7778/imtapp//app/errorMsg.xsd"><responseC
ode>1</responseCode><message>User is not logged in.</message></response>
PL/SQL procedure successfully completed.