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. >>> [EMAIL PROTECTED] 20/07/2007 12:50 >>> > -----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: 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
