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:
Advertisements
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
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 
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
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
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
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
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
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
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
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
oracle database backup using jsp
oracle database backup
using jsp I want to take the backup of
oracle database.I want to write the code in jsp ,so that when the page is loaded a backup of the database is
stored in one of my local drives.Is it possible to do
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
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
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
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
Passing classid or name in request using Jquery
Passing classid or name in request
using Jquery Hi, I am new to JQuery.I have a servlet that I am calling
using jquery.I have some parameters like filename,userid that I am
passing to the servlet to upload a file.I have
created
Create XML File using Servlet
Create
XML File
using Servlet
 ...
XML file with its version and encoding and display a message '
Xml
File
Created Successfully'.
JAXP (
Java API for
XML Processing) is a
Java
image store in oracle using jswing
image store in
oracle using jswing hello ,ihave searched the image store in
oracle using jswing but i did not find the code please help me
Pagination in jsp using oracle and not sql
Pagination in jsp
using oracle and not sql I need the code for pagination in jsp
using oracle.
I already tried it with rownum between instead... Pagination
using Mysql database
<%@ page language="
java" %>
<%@ page