1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

10g: How do I print results from a query

Discussion in 'General' started by tripower, Aug 27, 2010.

  1. tripower

    tripower Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    I am testing this in both SQL Tools and Navigator and I cannot get the results to print. The statement runs fine but the 'printed' results do not show up anywhere. Here is my test:

    BEGIN
    DBMS_OUTPUT.PUT_LINE('Test');
    END;


    AM I missing something here?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Yes. If you do not code DBMS_OUTPUT.ENABLE(1000000); the buffer is not displayed.
    Another option is to do this at a SQL> prompt:

    set serveroutput on size 1000000

    There may also be an option in the GUI to enable server output; check your application documentation.