<code>Tom

What about dbms_epg package in 10g

</code>

Tom

But the dbms_epg dones not require any web server to invoke.....right.

Thanks

Tom

Following t-sql code from sqlserver end point creation

DROP ENDPOINT sql_endpoint;
GO

CREATE ENDPOINT sql_endpoint 
STATE = STARTED
AS HTTP(
   PATH = '/sql', 
   AUTHENTICATION = (INTEGRATED ), 
   PORTS = ( CLEAR ), 
   SITE = 'SERVER'
   )
FOR SOAP (
   WEBMETHOD 'GetSqlInfo' 
            (name='master.dbo.xp_msver', 
             SCHEMA=STANDARD ),
   WEBMETHOD 'DayAsNumber' 
            (name='master.sys.fn_MSdayasnumber'),
   WSDL = DEFAULT,
   SCHEMA = STANDARD,
   DATABASE = 'master',
   NAMESPACE = 'http://tempUri.org/'
   ); 
GO

In the same way i would like to create a PL/SQL end-point wsdl.

Could you pl. guide me in this regard.

Tom

Thank you for your reply, but the links you have given pointing to "How to consuming the wsdl". Where as i need info for creating the above end-points.

Thanks

TOM

I have found the useful link relating to this PL/SQL SOAP provider. see below 

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11410

Which seems to be totally PL/SQL based, but I would like to conclude this session by putforthing the final question relalting to this dbms_epg, which is "how the performance will be during consumption of this type of SOAP service having millions of records in datanase. The consumption will be either from an another database PL/SQL type or from the application>
<code>I appreciate your feedback in this reagrd.

Thanks

Tom

Thanks for your time.

Hello Tom,

My requirement is very similar to the first question here, i.e, to consume a Web Service using PL/SQL code. I have a working application in 11g database that sends HTTP SOAP requests using the UTL_HTTP package as follows:

FUNCTION f_invoke(p_soap_msg VARCHAR2,
p_action VARCHAR2,
p_timeout VARCHAR2 DEFAULT 60)
RETURN CLOB
IS
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
l_soap_response VARCHAR2(32767);
l_response_clob CLOB;
BEGIN
UTL_HTTP.set_transfer_timeout(p_timeout);

l_http_request := UTL_HTTP.begin_request(p_url, 'POST', UTL_HTTP.http_version_1_1);

UTL_HTTP.set_header(l_http_request, 'Content-Type', 'text/xml; charset="utf-8"');
UTL_HTTP.set_header(l_http_request, 'Content-Length', LENGTH(p_soap_msg));
UTL_HTTP.set_header(l_http_request, 'SOAPAction', p_action);

UTL_HTTP.write_text(l_http_request, p_soap_msg);
l_http_response := UTL_HTTP.get_response(l_http_request);

DBMS_LOB.createtemporary(l_response_clob, TRUE, DBMS_LOB.call);
DBMS_LOB.open(l_response_clob, DBMS_LOB.lob_readwrite);

BEGIN
LOOP
UTL_HTTP.read_text(l_http_response, l_soap_response, 32767);
DBMS_LOB.writeappend(l_response_clob, LENGTH(l_soap_response), l_soap_response);
END LOOP;
EXCEPTION
WHEN UTL_HTTP.end_of_body
THEN
UTL_HTTP.end_response(l_http_response);
END;

DBMS_LOB.close(l_response_clob);
DBMS_LOB.freetemporary(l_response_clob);

RETURN l_response_clob;
END f_invoke;

Now I need to implement this same solution in a way so that the HTTP call-out is not initiated directly by the database but routed via an Application Server (WebLogic in my case) so that my application conforms to the organization's architecture principles. Could you help me with this?

Thanks,
Krishna.