illegal use of LONG datatype pts@ptsmig.world> begin 2 for a in (select * from t1) loop 3 insert into t2 values(a.x, a.y); 4 end loop; 5 end; 6 / PL/SQL procedure successfully completed. pts@ptsmig.world> select * from t2; X --- Y --- 1 abcde When I am doing a Se...
In 8i and up, this will work: ops$tkyte@ORA8I.WORLD> create or replace function getlong( p_tname in varchar2, 2 p_cname in varchar2, 3 p_rowid in rowid ) return varchar2 4 as 5 l_cursor integer default dbms_sql.open_cursor; 6 l_n number; 7 l_long_val varchar2(4000); 8...