"PLS-00382: expression is of wrong type" error
Date: 9 May 2002 09:17:28 -0700
Message-ID: <b4810052.0205090817.2b5ec71d_at_posting.google.com>
I am trying to get data from a LONG column into something I can easily
view. I tried pulling it into a varchar2, but ran into a problem with
one of values being longer than 4000.
So I'm trying to use a CLOB, and am not sure why the following isn't
working:
my_tab2 has only one column, a CLOB.
When I run the above I get the error in the "PLS-00382: expression is
declare
cursor my_cursor is
select my_col
from my_tab1;
my_var CLOB;
begin
open my_cursor;
loop
execute immediate 'fetch my_cursor into my_var';
exit when my_cursor%notfound;
insert into my_tab2 values (my_var);
end loop;
close my_cursor;
end;
/
Any help is appreciated.
Phil Received on Thu May 09 2002 - 18:17:28 CEST