Re: Looking for a package for debuging purpose

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 \ / 
////)
   \       /                         |                              \    
    /
    \     /                                                          \   
   /
    /   /                                                              \ 
   \
   /   /                                                                
\    \


--