RE: Invoking sql files in ANT.

2007-07-20 Thread Chun Ji
-Original Message- From: Priest, James (NIH/NIEHS) [C] [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 4:50 AM To: Ant Users List Subject: RE: Invoking sql files in ANT. Importance: Low > -Original Message- > From: Chun Ji [mailto:[EMAIL PROTECTED] > I was

RE: Invoking sql files in ANT.

2007-07-20 Thread Mike Stewart
Check out http://tahiti.oracle.com/pls/db92/db92.error_search?search=01000 a handy site for checking the error messages. ORA-00922 missing or invalid option Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specif

RE: Invoking sql files in ANT.

2007-07-20 Thread Priest, James (NIH/NIEHS) [C]
> -Original Message- > From: Chun Ji [mailto:[EMAIL PROTECTED] > I was trying to call some sql files from ANT, and it keeps > giving me some "ORA-00922, ORA-00900.." errors. I don't think Charlie - I take it by the error messages you are using Oracle - check out my wiki post here: ht

Invoking sql files in ANT.

2007-07-19 Thread Chun Ji
Hi all, I was trying to call some sql files from ANT, and it keeps giving me some "ORA-00922, ORA-00900.." errors. I don't think there is anything special in the ant/build.xml, but is because something in the sql file that ANT/SQL can not recognize, such as: " set define off ... spool exe