You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ant.apache.org by Johan Adelöw <jo...@corustechnologies.com> on 2000/11/06 19:14:04 UTC

SQLexec task

The SQLtasks lacks ability to create triggers, stored procedures and
functions for Oracle databases since oracle uses ";"  as delimiter in the
trigger/proc/func code. This is a huge drawback when installing databas
stuff.
 
A workaround could be that the delimiter could be replaced with for instance
"/" as in Sqlplus. 
Has anyone else thought about this?

/Johan

_________________________________________________
 
E-mail: johan.adelow@corustechnologies.com
Direct: +46-8-678 80 60
Mobile: +46-70-563 13 97
Office: +46-8-4403860 (Always open)
Home page: www.corustechnologies.com
_________________________________________________

RE: SQLexec task

Posted by Alan Gerhard <AG...@E-SyncNet.Com>.

SQLexec taskmight be better to be able to set the delimiter character - unless that function is already present..

alan.gerhard

 -----Original Message-----
From: Johan Adelöw [mailto:johan.adelow@corustechnologies.com]
Sent: Monday, November 06, 2000 1:14 PM
To: ant user mailing list
Subject: SQLexec task

  The SQLtasks lacks ability to create triggers, stored procedures and functions for Oracle databases since oracle uses ";"  as delimiter in the trigger/proc/func code. This is a huge drawback when installing databas stuff.

  A workaround could be that the delimiter could be replaced with for instance "/" as in Sqlplus. 
  Has anyone else thought about this? 

  /Johan 

  _________________________________________________ 

  E-mail: johan.adelow@corustechnologies.com 
  Direct: +46-8-678 80 60 
  Mobile: +46-70-563 13 97 
  Office: +46-8-4403860 (Always open) 
  Home page: www.corustechnologies.com 
  _________________________________________________