passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC

Ads
 

passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC

I want to send the xml as input parameter to the stored procedure.XML will be created using DocumentBuilderFactory and it is to be send using JDBC. Stored procedure in oracle database will contains two input parametes and an output parameter.first input parameter is an integer and second one receives xml as input and parse it according to the columns in table and performs further operations.third one is the out parameter that gives the result either success/failure. All the work related with procedures,creating xml are completed and working fine,but i can't able to send the xml created using the documentbuilder to the stored procedure.I tried by using XMLType/Clob format..no use..Everytime i am getting the same error.Exception in thread "main" java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PRCNUMBERRANGE_INSERTION' ORA-06550: line 1, column 7:

here is my java code... import java.io.; import javax.xml.parsers.; import javax.xml.transform.; import javax.xml.transform.dom.; import javax.xml.transform.stream.*;

import oracle.jdbc.OraclePreparedStatement; import oracle.jdbc.OracleCallableStatement; import oracle.jdbc.OracleResultSet; import oracle.jdbc.OracleTypes; import oracle.xdb.XMLType;

import oracle.xdb.dom.XDBDocument; import oracle.xdb.dom.XDBDomImplementation;

import org.w3c.dom.*;

import java.sql.CallableStatement; import java.sql.Clob; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.SQLXML; import java.sql.Statement; import java.sql.Types;

import java.util.ArrayList; public class xml3 { public static void main(String[] args) throws Exception {

DocumentBuilderFactory documentBuilderFactory = DocumentBuilderFactory.newInstance(); DocumentBuilder documentBuilder = documentBuilderFactory.newDocumentBuilder(); Document document = documentBuilder.newDocument(); Element rootElement = document.createElement("Request"); document.appendChild(rootElement); Element em = document.createElement("NumbersToPort"); Element em1= document.createElement("TelephoneNumberFrom"); Element em2= document.createElement("TelephoneNumberTo"); em1.appendChild(document.createTextNode("9980000000")); em2.appendChild(document.createTextNode("9980000000")); em.appendChild(em1); em.appendChild(em2); rootElement.appendChild(em);

TransformerFactory transformerFactory = TransformerFactory.newInstance(); Transformer transformer = transformerFactory.newTransformer(); DOMSource source = new DOMSource(document); StreamResult result = new StreamResult(System.out); transformer.transform(source, result);

Connection con=null; Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("driver specific........."); con = DriverManager.getConnection("jdbc:oracle:thin:@10.100.23.155:1521:WNPG", "WEBSERVICE", "WEBSERVICE"); System.out.println("successfully connected........."); OracleCallableStatement stmt=(OracleCallableStatement) con.prepareCall("{ call PKGNUMBERRANGE.prcnumberrange_insertion(?,?,?)}"); System.out.println("calling the procedure.."); XMLType poXML = XMLType.createXML(con, document); stmt.setString(1,"120"); System.out.println("id passed as param.."); stmt.setObject(2,poXML); System.out.println("xml passed as param..");

stmt.registerOutParameter(3,OracleTypes.CURSOR); System.out.println("recv the output as param.."); ResultSet rset=stmt.executeQuery(); System.out.println("call executed.."); OracleResultSet rs_single = (OracleResultSet) rset;

while(rs_single.next()) { System.out.println("return value.."+rs_single.getString(1)); }

con.commit(); con.close(); } }

Please give any solution..

View Answers

Ads









Related Tutorials/Questions & Answers:
passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC
passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC  I want to send the xml as input parameter... and it is to be send using JDBC. Stored procedure in oracle database will contains two
servelet connectivity with oracle using procedure
servelet connectivity with oracle using procedure   kindly elaborate how servlet code connect to oracle br using procedure
Advertisements
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp  iam a fresher newbie to softparsing i... procedure for inserting data into oracle database as bind variable and same
Insert Data in Table Using Stored Procedure
are using CallableStatement to execute a stored procedure into java code... data into a table using stored procedure. Steps: 1.Create database... Insert Data in Table Using Stored Procedure 
creating and executing stored procedure using hibernate
creating and executing stored procedure using hibernate  I have to execute following query using hibernate DECLARE @i_STARTDATETIME DATETIME DECLARE @i_ENDDATETIME DATETIME DECLARE @o_ERRORCODE INT DECLARE @o_ERRORDESCRIPTION
Stored Data in XML File using Servlet
Stored Data in XML File using Servlet  ... to stored data in xml file using Servlet  We have created  file login.jsp... a message 'Xml File Created Successfully'.   JAXP (Java API for XML
Read XML using Java
of all i need to read xml using java . i did good research in google and came to know.../xmlParsing/java-xml-parsing-using-sax.shtml http://www.roseindia.net/xml/sax...Read XML using Java  Hi All, Good Morning, I have been working
xml file reading using java
xml file reading using java  hi deepak I want to read some data from xml file and send that output to particular email address using java  ...)throws Exception{ DocumentBuilderFactory docFactory
read xml using java
read xml using java  <p>to read multiple attributes and elements from xml in an order.... ex :component name="csl"\layerinterfacefile="poo.c... is only allowed to take place using this layer. The data stored is composed
Insert or retrieve image into oracle 10g by using java
Insert or retrieve image into oracle 10g by using java   How can i insert or retrieve image into oracle10g using java plz i need it urgently,need guidance to do this plz
parsing xml file using java code
parsing xml file using java code  parsing a xml file using java code
excel file using JDBC java.?
excel file using JDBC java.?  hey, i am a telecomm. engineer , and i am try to develop a tool which reads from a excel file and then appends the same... used JDBC ODBC to read from excel file. i am not able to append it using
JDBC CallableStatement Example
statement provides a way to call the stored stored procedure of the database... is give below which calls the stored procedure HI() from database student. At first create a database student in MySql Then Create a Stored procedure
JPA 2.1 Stored Procedure Example
for programmers. You can easily call stored procedure from your Java.... These are database specific and created using the SQL statements. In oracle this language is called PL/SQL. Oracle database server also supports stored procedure
Interceptors Configuration using Java or XML
In this section, you will learn about how to configure interceptors using Java or XML
how to create xml schema from xml doc using java
how to create xml schema from xml doc using java  i want to create xml schema from xml document programatically using java... am using Netbeans IDE 7.0 i hav created the xml document for a table of data from Database... now i
Exception while inserting image in oracle using java
Exception while inserting image in oracle using java  import...()); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost... affected: "+stmt.executeUpdate()); } } My Oracle table description is: create table
xml Converting to java using JDOM
xml Converting to java using JDOM  Hello , I am new to java and JDom so i make a Xml file and i need help to read it from java using objects , my... should be inside a student object i will include the java code and xml code and i
how to read and write an xml file using java
how to read and write an xml file using java  Hi Can anyone help me how to read and write an xml file which has CData using java
Sending and receiving xml message using Java Program
Sending and receiving xml message using Java Program  Hi Friends, I want to send and receive xml files between two java programs using wire format, could you suggest me the steps to be followed to acheive it or suggest some
Sending and receiving xml message using Java Program
Sending and receiving xml message using Java Program  Hi Friends, I want to send and receive xml files between two java programs using wire format, could you suggest me the steps to be followed to acheive it or suggest some
Passing parameters in JSP using forward.
Passing parameters in JSP using forward.  If a page is forwarded to another page using jsp:forward, is it necessary that the page should be already created? Or will the compiler create one?   Hi, it necessary
stored procedure
stored procedure  what is stored procedure
Passing a parameter using URL string
Passing a parameter using URL string  How to pass a parameter using the URL string in a JSF application
How to Split a large XML file using java?
How to Split a large XML file using java?  How can we split a 500MB Xml file?I know how to split xml file after reading the entire document in a file.Here we cannot load the entire file as it is a large file
How to read value from xml using java?
How to read value from xml using java?  Hi All, I want to read value from following xml using java.. In <Line>,data is in format of key... in advance <pre lang="xml"> &lt;?xml version="1.0" encoding="UTF-8" ?>
How to values from xml using java?
How to values from xml using java?  Hi All, I want to read value from following < Line> xml using java.. In < Line>,data is in format of key and value pair.. i want to read only values..could u plz help me
HOW TO SAVE XML INTO MYSQL AND RETRIEVE IT USING JAVA
HOW TO SAVE XML INTO MYSQL AND RETRIEVE IT USING JAVA  H ello, i have an xml code, i need to save it into mysql 5.5 server database using java. i... as xml and retrieve it the same way i saved it. SOMEONE PLEASE HELP.... this is my
XML to DB2 Comparison using Java xpath
XML to DB2 Comparison using Java xpath  Hi , I am a manual tester...' products . i want to compare these xml values with db2 using Java. I have Good knowledge in C, C++ and Ok with java. I am planning to use xpath to get details
using Blob in jdbc - JDBC
"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost...using Blob in jdbc  Hi, I got an Exception when i was trying to insert one image into oracle 10g database the exception is Exception in thread
stored procedure
stored procedure  on storing values to database using stored procedure it throws an error lyk ADODB.Command error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another

Ads