ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sugandha Shah" <sugand...@cybage.com>
Subject Re: SQL
Date Tue, 16 Oct 2001 15:32:25 GMT
Hi,
Thanx for the prompt respponse.
If i  try removing that it says SQL statements executed successfully.
But still when i look in oracle DBA studio it shows procedure is invalid.?
It is pretty urgent.
Any help is appreciated.

Thanx
-Sugandha


----- Original Message ----- 
From: "Magesh Umasankar" <umagesh@rediffmail.com>
To: <ant-user@jakarta.apache.org>
Cc: "sugandha shah" <drsugandha@yahoo.com>
Sent: Tuesday, October 16, 2001 7:15 PM
Subject: Re: SQL



Try removing the ; after vchcategory_id

To find out what is causing the problem, run ant in 
verbose mode (ant -verbose).

On Tue, 16 Oct 2001 sugandha shah wrote :
> Hi Johan,
>  If you could send modified Sql task, it will  be
> really helpful.
> 
> Basically storedproc.sql contains this script :
> 
> CREATE OR REPLACE PROCEDURE
> SEL_CATEGORY_DATA(vchcategory_id IN
> VARCHAR2,vchcat_name OUT VARCHAR2,vchcat_Lang OUT
> VARCHAR2,vchcat_desc OUT
> VARCHAR2)  IS
> BEGIN
>    SELECT imode_category_name
> ,imode_category_language,imode_category_desc
> into vchcat_name,vchcat_Lang, vchcat_desc FROM
> Imode_CATEGORY WHERE
> IMODE_CATEGORY_ID = vchcategory_id;
> END SEL_CATEGORY_DATA;
> 
> Now my build.xml contains :
> <project name="MyProject" default="sql" basedir=".">
>  <target name="sql1" depends="sql" description=
> "creates tables">
>     <sql
>     driver= "oracle.jdbc.driver.OracleDriver"
>     url = "jdbc:oracle:thin:@Sugandha:1521:Intelli"
>     userid = "imode_user"
>     password = "imode"
>     onerror = "continue" >
>   <transaction  src="StoredProc.sql" />
>  </sql>
> </target>
> </project>
> 
> This doesn't work . Any help will be appreciated.
> 
> 
> Thanx
> -Sugandha
> 
> -----Original Message-----
> From: Sugandha Shah [mailto:sugandhas@cybage.com]
> Sent: den 15 oktober 2001 15:37
> To: ant-user@jakarta.apache.org
> Subject: SQL
> 
> 
> Hi
> I want to execute sql script which has stored
> procedure in it .
> I 'm able to create user ,create table etc.
> But not able to run sql with stored procedure.
> 
> Has any one any suggestions?Any help will be
> apppreciated.
> 
> Thanx
> -Sugandha
> 
> 
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
 



Mime
View raw message