Have you looked at this? http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-9af89d84f b1c39b1ef310505f7c6e3f4e53976bf
MG -----Original Message----- From: Dressler,Erik(externe MA) [mailto:[EMAIL PROTECTED] Sent: Friday, June 10, 2005 10:55 AM To: 'Apache Torque Users List' Subject: running a stored procedure or a function hello, everybody! i MUST run a stored procedure via torque!!! there are nearly no qualitative results by googling the problem. please check my trials: String sql = "exec test.testprocedure 100, 100, 100, 100, 'SVGIMAGE' "; or String sql = "exec test.testprocedure 100, 100, 100, 100, SVGIMAGE"; or String sql = "exec test.testprocedure ( 100, 100, 100, 100, SVGIMAGE )"; or String sql = "exec test.testprocedure ( 100, 100, 100, 100, 'SVGIMAGE' )"; List records = BasePeer.executeQuery(sql); all these trials caused the same error: 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)... the number are the in-values and svgimage is an out-value. please help!!! greetz, erik * * * * * * D I S C L A I M E R * * * * * * * This message is confidential and intended for the named addressee(s) only. If you are not the intended recipient, please contact the sender by E-Mail return and then delete this message from your system. You should not copy or use it or disclose its contents to any other person. If any part of this message is illegible or if you suspect that the message may have been intercepted or amended, please contact the sender. Dresdner Bank Luxembourg S.A. cannot accept any responsibility for the accuracy or completeness of this message without further investigation. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
