What is the answer?
> ----------
> From: Sharat Babu[SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology.
> Sent: 30 January 2000 22:19
> To: [EMAIL PROTECTED]
> Subject: Re: pls any one help me : sql exception from jdbc to oracle
> stor ed p rocedure
> Importance: High
>
> I got the answer.
>
>
> -----Original Message-----
> From: Sharat Babu [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 30, 2000 3:10 PM
> To: [EMAIL PROTECTED]
> Subject: pls any one help me : sql exception from jdbc to oracle stored
> p rocedure
> Importance: High
>
>
> > Hi
> >
> > This is the stored procedure :
> >
> > public boolean getStoredProcedureExample(String
> procedureName,String
> > Param1,String Param2) throws SQLException
> > {
> > try
> > {
> > String param1 = "store";
> > String param2 = "store";
> > System.out.println(procedureName+Param1+Param2);
> > // for sample test i have given the stored
> procedure
> > in the call statement itself.
> >
> >
> > CallableStatement H_CallableStatement =
> > dbCon.prepareCall(" { call fsdP_CONNTYPES_INS(?,?) } ");
> >
> >
> >
> > //setting the type of input parameters
> > H_CallableStatement.setString(1,param1);
> > H_CallableStatement.setString(2,param2);
> >
> > H_CallableStatement.executeUpdate();
> >
> > H_CallableStatement.close();
> >
> > return true;
> >
> > }catch(SQLException sqle)
> > {
> >
> > sqle.printStackTrace();
> > return false;
> >
> > }
> > }
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I am getting this exception :
> >
> > java.sql.SQLException: ORA-00900: invalid SQL statement
> >
> > at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled
> Code)
> > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code)
> > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java,
> Compiled
> > Code)
> > at
> > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738)
> > at
> > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java,
> > Compiled Code)
> > at
> >
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:123
> > 2)
> > at
> >
> oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java
> > :1353)
> > at
> > oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1760)
> > at
> >
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.ja
> > va:1805)
> > at
> >
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedSta
> > tement.java:320)
> > at
> projectCode.DbAccess.getStoredProcedureExample(DbAccess.java:189)
> > at
> >
> projectCode.utilityConnectionTypeDataAccess.setDataString_ins(utilityConne
> > ctionTypeDataAccess.java:93)
> > at
> >
> jsp.project.UtilityConnectionType1._jspService(UtilityConnectionType1.java
> > , Compiled Code)
> > at
> > com.livesoftware.jsp.HttpJSPServlet.service(HttpJSPServlet.java:31)
> > at com.livesoftware.jsp.JSPServlet.service(JSPServlet.java:118)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
> > at com.livesoftware.jrun.JRun.runServlet(JRun.java, Compiled Code)
> > at
> > com.livesoftware.jrun.JRunGeneric.handleConnection(JRunGeneric.java,
> > Compiled Code)
> > at
> >
> com.livesoftware.jrun.service.web.JRunWebServiceHandler.handleOutput(JRunW
> > ebServiceHandler.java, Compiled Code)
> > at
> >
> com.livesoftware.jrun.service.web.JRunWebServiceHandler.handleRequest(JRun
> > WebServiceHandler.java, Compiled Code)
> > at
> >
> com.livesoftware.jrun.service.ThreadConfigHandler.run(ThreadConfigHandler.
> > java, Compiled Code)
> >
> >
> >
> > Sharath Babu, Konda.
> > GE Power Systems,
> > Schenectady,NY.
> >
> > Ph: 518-385-2853(0)
> > 518-377-8024(R)
> > Home Page: www.geocities.com/sharat22
> >
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
