Re: 2k Limit?

A copy of this was sent to foo <blah_at_blah.com> (if that email address didn't require changing) On Tue, 04 May 1999 18:23:11 +0100, you wrote:

>Okay. I'm attempting to update values with the Perl DBI module with which I can
>execute sql statements.
>What I want to do is:
>
>$dbh->do("declare myvar long default '$longstring'");
>$dbh->do("update row set row=myvar where something='something'");
>
>but, the string in myvar has all kinds of weird characters that oracle is
>complaining about.
>The error is:
>

what is the contents of longstring. If longstring has a quote in it (single quote), you need to double them up. For example, lets say

longstring = "That's nice"

you need to make longstring = "That''s nice" (double up on the quotes) before just putting it in the string.

>. ( * @ % & = - + ; < / > in mod not rem an exponent (**)
>
><> or != or ~= >= <= <> and or like between is null is not ||
>
>I have no idea what that error message is saying, I just assumed that the special
>chars are the cause.
>Any clue how I can accomplish this from Perl?
>
>Thanks for the help!
>
>Thomas Kyte wrote:

[snip]

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue May 04 1999 - 19:15:30 CDT