You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Mike Stewart <MS...@mgtplc.com> on 2007/07/20 13:56:25 UTC
RE: Invoking sql files in ANT.
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 specify
that the column cannot contain any NULL values. Only constraints may
follow the datatype. Specifying a maximum length on a DATE or LONG
datatype also causes this error.
Action: Correct the syntax. Remove the erroneous option or length
specification from the column or storage specification.
Mike S.
>>> PriestJ@niehs.nih.gov 20/07/2007 12:50 >>>
> -----Original Message-----
> From: Chun Ji [mailto:CJi@pro-unlimited.com]
> 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:
http://www.thecrumb.com/wiki/Oracle%2C_SQL%2APlus_and_Ant
I've been using the Incanto tasks to run Oracle scripts and it works
great.
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org