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]>