Home » Developer & Programmer » JDeveloper, Java & XML » Creating Oracle Web service in Oracle 11g (11.2.0)
Creating Oracle Web service in Oracle 11g [message #586503] Fri, 07 June 2013 02:09
Anishkrithik
Messages: 23
Registered: June 2011
Location: TN
Junior Member
Hi,

We are trying to expose Stored Procedures in Oracle database as Web Services, As part of this, we did below setup and grants for 'TEST' user.

Based on link: http://www.oracle-base.com/articles/11g/native-oracle-xml-db-web-services-11gr1.php

DECLARE
  SERVLET_NAME VARCHAR2(32) := 'orawsv';
BEGIN
  DBMS_XDB.deleteServletMapping(SERVLET_NAME);
  DBMS_XDB.deleteServlet(SERVLET_NAME);
  DBMS_XDB.addServlet(NAME     => SERVLET_NAME,
                      LANGUAGE => 'C',
                      DISPNAME => 'Oracle Query Web Service',
                      DESCRIPT => 'Servlet for issuing queries as a Web Service',
                      SCHEMA   => 'XDB');
  DBMS_XDB.addServletSecRole(SERVNAME => SERVLET_NAME,
                             ROLENAME => 'XDB_WEBSERVICES',
                             ROLELINK => 'XDB_WEBSERVICES');
  DBMS_XDB.addServletMapping(PATTERN => '/orawsv/*',
                             NAME    => SERVLET_NAME);
END;
/
 
select * from xmltable('declare default element namespace "[url]http://xmlns.oracle.com/xdb/xdbconfig.xsd[/url]"; 
       for $doc in fn:doc("/xdbconfig.xml")/xdbconfig/sysconfig/protocolconfig/httpconfig/webappconfig/servletconfig/servlet-list/servlet[servlet-name=''orawsv'']
       return $doc');
/
grant XDB_WEBSERVICES to TEST;
/
grant XDB_WEBSERVICES_OVER_HTTP to TEST;
/
grant XDB_WEBSERVICES_WITH_PUBLIC to TEST;
/
SELECT dbms_xdb.gethttpport FROM dual;
/
begin dbms_xdb.sethttpport(8080); end;
/
SELECT dbms_xdb.gethttpport FROM dual;
/


Then we tried to access below URL, not able to get wsdl output. Please help.
http://<host>:8080/orawsv/TEST/LOB_OUTPUT?wsdl

[Updated on: Fri, 07 June 2013 03:22]

Report message to a moderator

Previous Topic: invoking a JVM(on unix) from anotehr JVM(on oracle)
Next Topic: Creating Report from Oracle 9i tables
Goto Forum:
  


Current Time: Thu Mar 28 14:24:01 CDT 2024