Hi Gochwal Pl keep in mind i am using oracle sql statements not jdbc sql statements in my call's as i am using the same jsp for both sql and oracle database versions i have to keep the jsp calls similar
Thaks for Co-operation Hari -----Original Message----- From: Gochwal Meenu [mailto:[EMAIL PROTECTED]] Sent: Monday, November 05, 2001 11:07 AM To: [EMAIL PROTECTED] Subject: Re: Tomcat: jsp : JDBC & ORACLE There is some error in ur code Use it this way l_Stmt.registerOutParameter(1,Types.INTEGER); l_Stmt.execute(); int l_Return = l_Stmt.getInt(1); now check what l_Return returns What i mean to say was that instead of using this stored procedure use addBatch(String sql).In this pass the query which is to be executed. Then use updateBatch() which returns u the int[] array i.e the no of rows that where updated/inserted > -----Original Message----- > From: SriHari [SMTP:[EMAIL PROTECTED]] > Sent: Monday, November 05, 2001 10:45 AM > To: [EMAIL PROTECTED] > Subject: Tomcat: jsp : JDBC & ORACLE > > Hai > > by bean which executes the oracle stored procedure looks some thing like > this > > i am calling procedure from jsp > === > int param1=3; > String param2="testdhjkhghghjhgh"; > String squery2="ProxyzInsert "+param1+",'"+param2+"'"; > out.println(db.execDMLProc(squery2)); // i am getting -1 here i expect > 1 > or some interger > === > public int execDMLProc(String s) throws--- > { > ---- > if (procedure with out params) > { > cstmt = dbcon.prepareCall("{ call "+s+"}"); // where s is the string > } > ---- > if (procedure with params) > { > > SEPERATE PARAMETERS() > cstmt.setInt(1,Integer.parseInt(param1)); > cstmt.setString(2,param2; // setting parameters > ... > ... > // Now i tried > cstmt.getUpdatCount(); // returning -1 > or > cstmt.addBatch(); // getting -1 result > cstmt.executeBatch(); > } > ---- > } > > > > > > can any one explain me how to get no of records updated by executing > Oracle > stored Procedure > > > > Regards > Srihari > -----Original Message----- > From: Gochwal Meenu [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 05, 2001 10:05 AM > To: [EMAIL PROTECTED] > Subject: Re: Tomcat: jsp : JDBC & ORACLE > > > Hi > > use addBatch(String sql) > then executeBatch() which Submits a batch of commands to the database for > execution and if all commands execute successfully, returns an array of > update counts.This can be used incase u want to know the no of rows > updated. > > > > -----Original Message----- > > From: SriHari [SMTP:[EMAIL PROTECTED]] > > Sent: Saturday, November 03, 2001 3:54 PM > > To: [EMAIL PROTECTED] > > Subject: Tomcat: jsp : JDBC & ORACLE > > > > Hai all > > > > By using JDBC CallableStatement i am executing Oracle Stored Functions > > and > > Procedures > > In Procedures like Insert Update and Delete I have to know the no of > > records updated > > When i am calling a Oracle Stored Procedure processing(DML operations > > like > > insert,update,delete) > > commands > > How can i get the Inserted/Deleted/Updated no of Record as > > callablestatement.getUpdateCount method dosent return no of rows > effected > > > > > > > > > > > > Thanks > > Srihari > > -----Original Message----- > > From: SriHari > > Sent: Wednesday, October 31, 2001 6:47 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Tomcat: jsp : JDBC & ORACLE > > > > > > Thanks for the code > > i am using classes111.zip > > i was not getting > > OracleTypes from oracle.jdbc.OracleTypes > > can u point me to the resource > > > > > > Thanks Again > > > > Srihari > > > > > > -----Original Message----- > > From: Jan Aren� [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 31, 2001 6:09 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Tomcat: jsp : JDBC & ORACLE > > > > > > Here is how I do > > > > rs = ResultSet > > cstmt = CallableStatement > > > > > > cstmt = conn.prepareCall("begin PACKAGE.procedure(?,?,?); end;"); > > > > cstmt.registerOutParameter(1, OracleTypes.CURSOR); > > cstmt.setString(2, para1); > > cstmt.setString(2, para2); > > > > cstmt.execute(); > > > > rs = ((OracleCallableStatement)cstmt).getCursor(1); > > > > while(rs.next()) > > { > > // Like a normal rs > > } > > > > As you can see I have the Cursor as a parameter, but if you have a > > "storedFunction" I guess you could return the Cursor also... > > > > Hoped it helped > > > > // Jan Aren� > > > > -----Ursprungligt meddelande----- > > Fr�n: A mailing list about Java Server Pages specification and reference > > [mailto:[EMAIL PROTECTED]]F�r SriHari > > Skickat: den 31 oktober 2001 12:06 > > Till: [EMAIL PROTECTED] > > �mne: Tomcat: jsp : JDBC & ORACLE > > > > > > I am using Stored(Functions) in oracle which return cursors > type(multiple > > rows) > > > > How can i allot them to resultset in jsp /Java code > > How to call the function in java code so that i can use the rows just > like > > i > > have used the result using SQL server/Access as my database > > > > ie i have used Resultset in SQL database (Result set in java code) > > how can i use Cursors in Oracle to use them in jsp/java (???????); > > > > > > Regards > > SriHari > > > > > ========================================================================== > > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > > ========================================================================== > > = > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > > ========================================================================== > > To > > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > > ========================================================================== > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > ========================================================================== > To > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > > ========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com ==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
