ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivan Ivanov <rambiusparkisan...@yahoo.com>
Subject RE: Error while executing the database procedure.
Date Fri, 04 Jun 2004 10:37:51 GMT
Just ideas,

I took a look in SQLExec task and JDBCTask APIs and
sources. The problem seems to be that SQLExec is using
 Statement and not a CallableStatement and hence
ora-00900 error.

I think that you can create a custom task that extends
JDBCTask and execute your procedure in it with
CallableStatement's.

I wonder whether it is possible to redesign SQLExec in
such a way that it recognizes procedures and executes
them via CallableStatements?

Ivan

--- vinod.nayak@iflexsolutions.com wrote:
> Yes, you are right..
> 
> -----Original Message-----
> From: Ivan Ivanov
> [mailto:rambiusparkisanius@yahoo.com] 
> Sent: Friday, June 04, 2004 3:11 PM
> To: Ant Users List
> Subject: RE: Error while executing the database
> procedure.
> 
> 
> --- vinod.nayak@iflexsolutions.com wrote:
> > Yes,
> > 
> > SQL Statements are correct. After compiling the
> > procedure through Ant
> > scripts, I executed the same procedure through
> > SQLPlus prompt
> > successfully.
> 
> If so, the question now is how to execute a
> procedure
> from Ant build.xml, isn't it?
> 
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/ 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> user-unsubscribe@ant.apache.org
> For additional commands, e-mail:
> user-help@ant.apache.org
> 



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message