Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 64968 invoked from network); 10 Jun 2005 14:55:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 10 Jun 2005 14:55:22 -0000 Received: (qmail 28733 invoked by uid 500); 10 Jun 2005 14:55:20 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 28712 invoked by uid 500); 10 Jun 2005 14:55:19 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 28650 invoked by uid 99); 10 Jun 2005 14:55:19 -0000 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail06.allianz.de (HELO mail06.allianz.de) (194.127.3.26) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 10 Jun 2005 07:55:17 -0700 Received: from mail03.allianz.de (rmx0323.muc.allianz [192.168.5.23]) by mail06.allianz.de with ESMTP id j5AEssPh028991 for ; Fri, 10 Jun 2005 16:54:55 +0200 (MEST) Received: from rmx3606.muc.allianz ([194.127.36.6]) by mail03.allianz.de with ESMTP id j5AEshlZ023565 for ; Fri, 10 Jun 2005 16:54:44 +0200 (MEST) Received: from dblmxs1.dresdner-bank.lu ([171.25.98.6]) by rmx3606.muc.allianz (Switch-3.1.7/Switch-3.1.7) with ESMTP id j5AEsh26006764 for ; Fri, 10 Jun 2005 14:54:43 GMT Received: by dblmxs1 with Internet Mail Service (5.5.2653.19) id ; Fri, 10 Jun 2005 16:54:14 +0200 Message-ID: <4A2E265BA43ED5408940E6C0815899EB03B5097E@DBLMXS3> From: "Dressler,Erik(externe MA)" To: "'Apache Torque Users List'" Subject: running a stored procedure or a function Date: Fri, 10 Jun 2005 16:55:19 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org