Re: Bug in PL/SQL looking for a workaround
From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 11 Feb 93 21:32:34 GMT
Message-ID: <casivils.729466354_at_node_508ba>
Date: 11 Feb 93 21:32:34 GMT
Message-ID: <casivils.729466354_at_node_508ba>
In <C28q7J.5wL_at_mach1.wlu.ca> derwin_at_mach2.wlu.ca (Daryl Erwin) writes:
>On Sequent, Oracle 6 Forms3.0 , PL.SQL in a Procedure.
>Ill try to demonstrate...
>I have a LONG field called x.
>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!
This is just a guess, (my machine doesn't do that), try the copy procedure.
Craig Received on Thu Feb 11 1993 - 22:32:34 CET