Bug in PL/SQL looking for a workaround
From: Daryl Erwin <derwin_at_mach2.wlu.ca>
Date: Wed, 10 Feb 1993 16:09:18 GMT
Message-ID: <C28q7J.5wL_at_mach1.wlu.ca>
Date: Wed, 10 Feb 1993 16:09:18 GMT
Message-ID: <C28q7J.5wL_at_mach1.wlu.ca>
On Sequent, Oracle 6 Forms3.0 , PL.SQL in a Procedure. Ill try to demonstrate...
In :x I have stored '1<CR><CR>' (ie 1 and two carriage returns.
if I do length(:x) it is 3. Correct.
Now, in PL/SQL I have a variable y 'varchar[5000]'.
y := :x;
length(y) = 3. Correct.
now
:x := y;
length(:x) = 1. WRONG!
Can this be done!
How can I force the assignment of y to :x be be ALL 3 characters?
HELP! Received on Wed Feb 10 1993 - 17:09:18 CET