I'm not sure about this. I know that <sql> does a fair bit of
processing of the scripts it executes, so perhaps there is a flaw in its
parsing?
Does a -debug run of this yield any other relevant details?
Anyone using <sql> heavily have any ideas on this one?
Erik
[EMAIL PROTECTED] wrote:
> I tried it and it works fine if I append the "@tnsname" to the username and password.
> The sql tag also works fine for me but when I try to execute the sql script it can't
>execute the following lines of SQL(same behaviour when I use the exec task):
>
> CREATE OR REPLACE TRIGGER TRBISQ_ASSETS_REPORTS BEFORE INSERT
> ON NOKIA_ASSETS_REPORTS REFERENCING NEW AS NEW FOR EACH ROW
> BEGIN
> SELECT SQ_NOKIA_ASSETS_REPORTS.NEXTVAL INTO :NEW.ID FROM DUAL;
> END;
>
> [sql] Failed to execute: END
> [sql] java.sql.SQLException: ORA-00900: invalid SQL statement
>
> Everything works fine in TOAD. Is the problem the ":NEW.ID" string?
>
> /G�ran
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
