Home -> Usenet -> c.d.o.tools -> Re: Looking for a package for debuging purpose

Re: Looking for a package for debuging purpose

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Fri, 7 Apr 2000 22:15:01 +0100
Message-ID: <8cmr9d$46m$1_at_news8.svr.pol.co.uk> 












Hi,


 


Maybe my program OraDebug is something for you. You 
can find it at http://www.oraxcel.com. 



 


OraDebug uses the following syntax: oradebug.debug( 
varchar2 ); It sends the messages to a Windows program for viewing. If the 
windows program is not running, the messages are not generated. If it is running 
you see the messages when they are generated.


 


All info about OraDebug is on the site: http://www.oraxcel.com


 


I invite people that have seen OraDebug before to 
have a look again. It's much improved now.


 


Regards, 



-- 
Gerrit-Jan Linker


 


web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com


 


Oraxcel: Linking Oracle to Excel
OraCodes: 
Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: 
PL/SQL debugger
OraWeb: Oracle access from IE



  
Christian BIERO <cbiero_at_gold-solutions.com> 
  wrote in message news:8ckrv1$n8k$1_at_front5m.grolier.fr...

  

Hello, I'm newbie in packages 
  creation.
I'm looking for a package (let's call it pac_debug)
which can 
  be called in other package to store debug information.
This package should 
  be disabled using a variable.

  
 

  

It looks like 
  :

  
 

  
pac_on    : set 
  pac_debug.flgdebug to TRUE
pac_off   : set pac_debug.flgdebug to 
  FALSE
pac_debug : put the message in table TB_DEBUG with the date if 
  pac_debug.flgdebug is TRUE 
  otherwise message is 
  ignored

  
 

  
Example:
========

  
 

  
another_package

  
 

  
blah
blah
pac_debug('my message 
  No1');
blah
blah
pac_debug('my message 
  No2');
blah
blah
pac_debug('my message No3');

  
 

  
end of another_package

  
 

  

I'll be happy to have any 
  example on which I can work on.
Thx

  

-- 
     
  _  ____________________________________________________________  
  _
    / ) |     BIERO 
  Christian      | Tél:     +33 
  (0)1 464 828 00  | ( \
   / /  
  |       O.I. 
  Synform       | FAX:     +33 
  (0)1 464 828 01  |  \ \
 _( /_  | _  37, rue du 
  Colonel    | 
  mailto:                     
  _ |  _) )_
(((\ \> |/ 
  )          Pierre Avia  
  |  cbiero_at_gold-solutions.com ( \| 
  </ /)))
(\\\\ \_/ /  75508 Paris Cedex 15  | http://www.gold-solutions.com \_/ 
  ////)
 \       
  /_________________________|______________________________\        
  /
  \    
  _/                                                          
  \_     /
  /   
  /                                                              
  \    \
 /   
  /                                                                
  \    \

Received on Fri Apr 07 2000 - 23:15:01 CEST












Original text of this message