Application Development Software

Hi All,

I am trying to call UCM Web Service (CheckIn.wsdl) using oracle.
But these web services are secured and expecting username/password.
Any one have any idea to pass username/password in oracle function.

My Code :-

CREATE OR REPLACE FUNCTION checkin (dDocName IN VARCHAR2,dDocTitle IN VARCHAR2,dDocType IN VARCHAR2,
dDocAuthor IN VARCHAR2,dSecurityGroup IN VARCHAR2,dDocAccount IN VARCHAR2,
primaryFile IN VARCHAR2)
return number
AS
l_service SYS.UTL_DBWS.service;
l_call SYS.UTL_DBWS.call;
newurl VARCHAR2(32767);
l_wsdl_url VARCHAR2(32767);
l_namespace VARCHAR2(32767);
l_service_qname SYS.UTL_DBWS.qname;
l_port_qname SYS.UTL_DBWS.qname;
l_operation_qname SYS.UTL_DBWS.qname;
l_xmltype_in SYS.XMLTYPE;
l_xmltype_out SYS.XMLTYPE;
BEGIN
l_wsdl_url := 'http://localhost:16200/cs/groups/secure/wsdl/custom/CheckIn?wsdl';
l_namespace := 'http://www.stellent.com/CheckIn/';
l_service_qname := SYS.UTL_DBWS.to_qname(l_namespace, 'CheckIn');
l_port_qname := SYS.UTL_DBWS.to_qname(l_namespace, 'CheckInSoap');
l_operation_qname := SYS.UTL_DBWS.to_qname(l_namespace, 'CheckInUniversal');
l_service := SYS.UTL_DBWS.create_service (
wsdl_document_location => URIFACTORY.getURI(l_wsdl_url),
service_name => l_service_qname);
l_call := SYS.UTL_DBWS.create_call (
service_handle => l_service,
port_name => l_port_qname,
operation_name => l_operation_qname);
l_xmltype_in := SYS.XMLTYPE('<?xml version="1.0" encoding="utf-8"?>
<CheckInUniversal xmlns="' || l_namespace || '">
<VARCHAR2>' || dDocName || '</VARCHAR2>
<VARCHAR2>' || dDocTitle || '</VARCHAR2>
<VARCHAR2>' || dDocType || '</VARCHAR2>
<VARCHAR2>' || dDocAuthor || '</VARCHAR2>
<VARCHAR2>' || dSecurityGroup || '</VARCHAR2>
<VARCHAR2>' || dDocAccount || '</VARCHAR2>
<VARCHAR2>' || primaryFile || '</VARCHAR2>
</CheckInUniversal>');
l_xmltype_out := SYS.UTL_DBWS.invoke(call_Handle => l_call,
request => l_xmltype_in);
SYS.UTL_DBWS.release_call (call_handle => l_call);
SYS.UTL_DBWS.release_service (service_handle => l_service);
END;

It's compiling successfully.

When ever i am trying to run using
SELECT checkin ('WEBSERVICE009','WEBSERVICE009', 'Document','weblogic','Private','IT/EBA/Distributor_testuser','D:/ucmfiles/test_WebService_11.txt') FROM dual;

It's expecting username/password...

Any body have any idea.