Hi
I have written a small anonymous block to read the text column from all_views. I declared a variable with text%type and reading the text column into the variable.
It is failing with ORA-06502: PL/SQL: numeric or value error. The Database version is 12C. Any known issue or any suggestions? Please help.
declare
def1 all_views.TEXT%TYPE;
len1 all_views.TEXT_length%TYPE;
begin
select text into def1 from all_views where view_name = 'RAM_LEG_CEN_FIX';
end;