Thanks Thomas.
But the error is the same.
Here is some message from the log file.
****************************************
......
Caused by: org.apache.torque.TorqueException: java.sql.SQLException:
ORA-00900: invalid SQL statement
at
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:200)
at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1395)
at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1343)
at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1293)
at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1256)
at
com.nequalsone.modules.actions.LoginUser.getUser(LoginUser.java:234)
at
com.nequalsone.modules.actions.LoginUser.doPerform(LoginUser.java:131)
... 39 more
Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:
1839)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1
764)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:2354)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:627
)
at
com.workingdogs.village.QueryDataSet.<init>(QueryDataSet.java:113)
at
org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:1384)
... 44 more
....
***********************************************
Any other instructions?
Appreciate.
Jill
-----Original Message-----
From: Thomas Vandahl <[EMAIL PROTECTED]>
Sent: Wed, 11 Jul 2007 20:33:38 GMT
To: Apache Torque Users List
Subject: Re: stored procedure
jill han wrote:
> String sql = "exec doLogin(" + clientName + ", " + username + ", " +
> password + ")";
My guess would be that clientName, username and password are strings
which need to be quoted in the SQL statement, like
String sql = "exec doLogin('" + clientName + "', '" + username + "', '"
+ password + "')";
Bye, Thomas.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
