How to create PLSQL webservice
Required Software
- OC4J version 9.0.3 or above; you will need the standalone full version (also known as OracleAS Java Edition)
- Oracle Database 10g
- Oracle SQL*Plus (included with the client or enterprise installation software)
- Java Software Developer's Kit (SDK) version 1.4 or above
Generating webservice ear
- Create a config.xml file
class="com.evermind.sql.DriverManagerDataSource" name="OracleDS" location="jdbc/OracleCoreDS" xa-location="jdbc/xa/OracleXADS" ejb-location="jdbc/OracleDS" connection-driver="oracle.jdbc.driver.OracleDriver" username="store"
password="store"
url="jdbc:oracle:thin:@localhost:1521:ORCL" inactivity-timeout="30"/> - Run the following command
set JAVA_HOME=c:\j2sdk1.4.2_06set
ORACLE_HOME=c:\oracle\oc4j
set CLASSPATH=.;%ORACLE_HOME%\webservices\lib\wsdl.jar;%ORACLE_HOME%\lib\xmlparserv2.jar;%ORACLE_HOME%\soap\lib\soap.jar
call %JAVA_HOME%\bin\java -jar %ORACLE_HOME%\webservices\lib\WebServicesAssembler.jar -config .\config.xml
