in reply to Oracle: string literal too long

The DBI documentation indicates that "When trying to insert long or binary values, placeholders should be used since there are often limits on the maximum size of an INSERT statement..."

So maybe you could try something like this:

$sth = $dbh->prepare(q{INSERT INTO table (BigChunk) VALUES (?)}); $sth->execute( $big_chunk );
I can't try this here, but give it a go and see if it works.

~CubicSpline
"No one tosses a Dwarf!"

Replies are listed 'Best First'.
Re: Re: Oracle: string literal too long
by Anonymous Monk on Jul 18, 2002 at 20:18 UTC
    I'm using Win32::ODBC, not DBI?