ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ritesh Rathore" <ritesh.rath...@tatainfotech.com>
Subject RE: Error while executing the database procedure.
Date Fri, 04 Jun 2004 11:09:25 GMT

Well, If someone is going to redesign SQLExec then
please add a flexibility to specify a character to separate column values
when printing sql results. (At present it separates column values by comma).

Ritesh

-----Original Message-----
From: Ivan Ivanov [mailto:rambiusparkisanius@yahoo.com]
Sent: Friday, June 04, 2004 4:08 PM
To: Ant Users List
Subject: RE: Error while executing the database procedure.


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


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


Mime
View raw message