> 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
