Hi Mallik,
I suspect you'll get more help on a DBI list, but right off the bat,
I'm wondering why it says "string literal too long". Are you adding
the data directly to an SQL query? In other words, are you doing
something like this?
INSERT INTO TABLE (name) VALUES ('$some_var');
Not only is that a potential security hole if done incorrectly, but I
believe some DBD's will choke if $some_var is too large. Try using a
bind variable and see if that avoids the problem:
my $sth = $dbh->prepare("INSERT INTO TABLE (name) VALUES (?)");
$sth->execute($some_var);
Cheers,
Ovid
--- Mallik <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> I am using oracle database and I have column of long data type. I
> insert the
> data into this column thru perl script. If the inserted data exceeds
> 4000
> chars, it is giving me the following error.
>
> DBD::Oracle::st execute failed: ORA-01704: string literal too long
> (DBD
> ERROR: OCIStmtExecute) at MT/TACDbManager.pm line 445.
>
> Whereas we can insert upto 2GB of data in long data type.
>
> Pl. help me out to solve this.
>
> Thanks & Regards,
> Mallik.
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> <http://learn.perl.org/> <http://learn.perl.org/first-response>
>
>
>
--
If this message is a response to a question on a mailing list, please send
follow up questions to the list.
Web Programming with Perl -- http://users.easystreet.com/ovid/cgi_course/
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
