db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dressler,Erik(externe MA)" <Erik.Dress...@Dresdner-Bank.lu>
Subject RE: running a stored procedure or a function
Date Mon, 13 Jun 2005 07:07:24 GMT

yes, i have! but this example does not work for my application. i found this
web-page, too.

i still need help...

> -----Original Message-----
> From:	Martin.Goulet@sungard.com [SMTP:Martin.Goulet@sungard.com]
> Sent:	10 June 2005 22:39
> To:	torque-user@db.apache.org
> Subject:	RE: running a stored procedure or a function
> 
> Have you looked at this?
> 
> http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-9af89d84fb1
> c39b1ef310505f7c6e3f4e53976bf
> 
> MG
> 
> -----Original Message-----
> From: Dressler,Erik(externe MA) [mailto:Erik.Dressler@Dresdner-Bank.lu]
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
 
*  *  *  *  *  *  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


Mime
View raw message