dba_views and column text (long type)
385668Apr 1 2005 — edited Apr 5 2005Hi,
when i excute this select :
select view_name||' '||
owner||' '||
to_char(text_length)||' '||
dbms_lob.substr(text_clob(view_name),text_length,1)
from sys.dba_views@my_link;
-- text_clob is a function wich convert long to clob
I have this error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
any suggestion.