Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_http and Oracle RTC xsd calls

435916Jan 6 2005
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2005
Added on Jan 6 2005
0 comments
155 views