hi, I'm trying to get a big audit on a forms screen and then to print it. while getting the error ORA-06502 because of too much data I want to route the output directly to the printer. the last command in the loop should be directed to the printer and not to window protokoll.
has anyone a good idea ?
thanks in advance
PROCEDURE PRINT_REPORTING_DETAILS (p_log_id IN NUMBER)
:protokoll.protokoll := NULL;
FOR I IN (SELECT log__txt
WHERE log__id = p_log_id
ORDER BY log__line)
:protokoll.protokoll := :protokoll.protokoll || I.log__txt || chr(10);