Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

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

Ads

 
 

Share on Google+Share on Google+

prem anand
passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC
0 Answer(s)      5 years and 10 months ago
Posted in : 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..

Ads
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
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
Difference between getting a document using DOMParser & DocumentBuilderFactory !!!
Difference between getting a document using DOMParser & DocumentBuilderFactory !!!  Hi, In DOM tutorials, on one page a document is formed using DocumentBuilderFactory and on the other page, document is formed using DOMParser
Error in MySQL Procedure Using JAVA Code
Error in MySQL Procedure Using JAVA Code  The following Java code (using Connector/J to create a stored procedure on MySQL 5.0) does not execute...("DELIMITER //\nCREATE PROCEDURE abdt (std INT)\nBEGIN\nSELECT attbegin, attend FROM
What is Stored Procedure?
the network by several clients using different input data. And when the procedure...What is Stored Procedure?  What is Stored Procedure?   Hi, Here is the answer, A stored procedure is a named group of SQL statements
remote procedure call using java - JSP-Servlet
remote procedure call using java  what is the romote procedure call and related coding in java?  Hi Friend, The RPC (Remote Procedure Call) is a mechanism that enables a remote procedure call from a client
accessing xml using java
accessing xml using java  I need to retrieve some elements in xml file using java   Hi Friend, Please visit the following links: http://www.roseindia.net/xml/Listingnode.shtml http://www.roseindia.net/xml/getting
stored procedure
stored procedure  what is stored procedure
XML parsing using Java - XML
XML parsing using Java  I'm trying to parse a big XML file in JAVA. The goal is like i will take console input from user until "Coverage" in element "MIRate"(THE XML code is below).once he enters coverage rate I need
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
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
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
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
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
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
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
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
What are the advantages of using Stored Procedures?
What are the advantages of using Stored Procedures?  What are the advantages of using Stored Procedures
store the image in the oracle using blob and get it back - JDBC
store the image in the oracle using blob and get it back  hi i am...("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin...(); } } --------------------------------------- In this program using jdbc driver
store the image in the oracle using blob and get it back - JDBC
store the image in the oracle using blob and get it back  hi i am facing problem in the following code . this code can store the image in table...("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin
update date from stored procedure
update date from stored procedure  how to works on insert,update data from stored procedure.   Insert data using stored procedure
parsing xml file using java code
parsing xml file using java code  parsing a xml file using java code
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
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
Interceptors Configuration using Java or XML
In this section, you will learn about how to configure interceptors using Java or XML