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!

print message

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

  1. hiswapna

    hiswapna Active Member

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

    I have a very length time taking procedure.

    I have put some debug messages using dbms_output.put_line

    but the messages are not getting printed until the procedure finishes the execution....

    is there any alternate way that I can see the messages immediately...some thing like log....rather than waiting a hour to finish the procedure and then see all the message at once

    Thanks
    Swapna
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Investigate using DBMS_PIPE.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    For testing purpose, you can use an Autonomous procedure that logs the message to table.