Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Debug message in file

Re: Debug message in file

From: Peter Bloch <peter.bloch_at_ubs.com>
Date: Fri, 25 Aug 2000 19:18:31 +0200
Message-ID: <39A6AA67.D5A96A73@ubs.com> 






    
  
  1.   dbms_output.put_line is fine for debugging

  
  2.   utl_file.put_line    is also good (large batch jobs,permanent)

  
  3.   The best is, you use your own procedure my_put_line 
   in all of your procedures !






In that way you can switch your Output to file or much better to a
log_table: 



insert into my_log(


   log_seq.nextval, 


  'var_a = ' || to_char(var_a) );
Received on Fri Aug 25 2000 - 12:18:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US