Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    15

    Question Unanswered: Forms 6i : PL/SQL print command ???

    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)
    IS
    BEGIN
    :protokoll.protokoll := NULL;

    FOR I IN (SELECT log__txt
    FROM lclog__t
    WHERE log__id = p_log_id
    ORDER BY log__line)
    LOOP
    :protokoll.protokoll := :protokoll.protokoll || I.log__txt || chr(10);
    END LOOP;
    END;
    Last edited by cpochmann; 12-01-03 at 06:51.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •