Hi all,
I am returning a large amount of data from a table column (datatype clob) in APEX. If I return using a sql statement (as an APEX report) then it displays fine. When using a cursor however I receive "ORA-06502: PL/SQL: numeric or value error".
The sql statment (which works fine) is:
Select cb_text from cb_follow_up;
The cursor code (not working):
DECLARE
cursor cur_follow_up is SELECT CB_TEXT
FROM CB_FOLLOW_UP;
typ_follow_up cur_follow_up%ROWTYPE;
BEGIN
HTP.P('<TABLE>');
OPEN cur_follow_up;
FETCH cur_follow_up into typ_follow_up;
WHILE cur_follow_up%FOUND
LOOP
HTP.P('<TR><TD>'||typ_follow_up.cb_text||'</TD></TR>');
END LOOP;
CLOSE cur_follow_up;
HTP.P('</TABLE>');
END;
Any help is much appreciated !
Greg
Message was edited by:
greg cox