ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sugandha shah <drsugan...@yahoo.com>
Subject SQL
Date Tue, 16 Oct 2001 06:17:35 GMT
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