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

Reply via email to