You can not use the sql task to perform operations like this cinsce the task is only designed for single sqlstatements and launches the code ar the first ";".
In your case create or replace trigger addresses_trg before insert on addresses for each row begin if :new.address_id is null then select addresses_seq.nextval into :new.address_id from dual; end if; which makes no sence to oracle. By using the delimiter option you can change the behaviour to launch at "/" on a single row. Thus it is possible to launch block statements. I have made a modified sqltask though, that is made especially to handle all kinds of Oracle statements that I can send you if you like. /Johan -----Original Message----- From: Gauti Reynisson [mailto:[EMAIL PROTECTED]] Sent: den 1 november 2001 14:21 To: [EMAIL PROTECTED] Subject: sql task doesn't execute script Hi! I have a problem with executing a sql script through the sql task. When I come to this decleration in the script: create or replace trigger addresses_trg before insert on addresses for each row begin if :new.address_id is null then select addresses_seq.nextval into :new.address_id from dual; end if; end; / ... it fails and says [sql] SQL: create or replace trigger cls_addresses_bir_trg before insert on cls_addresses_tb for each row begin if :new.address_id is null then select addresses_seq.nextval into :new.address_id from dual; [sql] -1 rows affected [sql] SQL: end if; [sql] Failed to execute: end if BUILD FAILED All tables and sequences have been created when this part is executed. Am I doing something wrong? cheers, Gauti PS. my ant task looks like: <sql driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@host:1521:orcl" userid="user" password="pass"> <transaction src="${database}/scriptName.sql"/> <classpath> <pathelement location="${lib}/oracle/jdbc/classes12.jar"/> </classpath> </sql> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>