How did you generate/create the clob script? I'm using clobs in mysql migrationdata imports and they work fine. I'm using mysqldump to create the sql file which correctly escapes those values.
I assume you have Oracle 11? (up 2 Oracle 10 it was imo only able to export to their own bin format) LieGrue, strub --- On Wed, 12/22/10, Jason Perry <jpe...@brightcove.com> wrote: > From: Jason Perry <jpe...@brightcove.com> > Subject: maven sql plugin and clobs > To: users@maven.apache.org > Date: Wednesday, December 22, 2010, 8:38 PM > Hi, > > I am running into a problem when trying trying to import a > .sql file that > has clob data. Anyone run into this or know of a > workaround? Here is the > failure: > > [INFO] > ------------------------------------------------------------------------ > [ERROR] BUILD ERROR > [INFO] > ------------------------------------------------------------------------ > [INFO] ORA-06550: line 6, column 15: > PLS-00103: Encountered the symbol " > <html> > <head> > <meta http-equiv="Content-Type" content="text/htm" when > expecting one of the > following: > > ( - + case mod new not null <an > identifier> > <a double-quoted > delimited-identifier> <a bind variable> avg > count current exists max min prior sql > stddev sum variance > execute forall merge time timestamp > interval date > <a string literal with character set > specification> > <a number> <a single-quoted SQL > string> pipe > <an alternatively-quoted string > literal > > Thanks, > -- Jay > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org