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!

Dbms_output

Discussion in 'SQL PL/SQL' started by hiswapna, Apr 20, 2010.

  1. hiswapna

    hiswapna Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Hi

    I have a lengthy procedure with intermediate dbms_output.put_line messages in between.

    The procedure when executed for a large number of values....it takes some time to finish the execution.

    the messages are printed only after complete execution is done.

    How can i see the messages immediately without waiting for the procedure to finish execution for all the values

    Thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    DBMS_OUTPUT won't display anything until the PL/SQL block has completed or if the buffer is filled to capacity which terminates the block with an error. You might invesitgate the DBMS_PIPE package.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Another way is to call an autonomous transaction to log the message into a temporary table. This is for testing purpose.
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India