Re: [Tora-develop] [Log4plsql] LOG4PLSQ - TOra integration

[<log...@li...>]

I've implemented the first way below in TOra for the 1.3.7 release. I've 
also added your template, so you should hopefully be pretty much set now 
when 1.3.7 is released.

/Mauritz
Underscore AB

MOULARD Guillaume OCISI wrote:

>Mauritz, 
>
>Yes, it is very good for LOGPLSQL if you add this template to TOra.
>
>If you whant read a log inside TOra you have 2 way.
>
>1. the most easy, it is by a reading a log table (see:vlog.sql).
>
>2. it is possible to use all LOG4J capability, for the dynamique 
>   parameters (Loggers, Appenders and Layouts)
>
>
>--g
>
>
>-----Message d'origine-----
>De : log...@li...
>[mailto:log...@li...]
>Envoye : lundi 29 juillet 2002 10:43
>A : MOULARD Guillaume 
>Cc : tor...@li...;
>Log...@li...
>Objet : Re: [Tora-develop] [Log4plsql] LOG4PLSQ - TOra integration
>
>
>This looks interesting. For really good integration you still need to be 
>able to look at the log from inside TOra which you still can't, but I'll 
>try to add that as soon as I can (Hopefully before 1.4). Can I add this 
>template to TOra?
>
>/Mauritz
>Underscore AB
>
>MOULARD Guillaume wrote:
>
>  
>
>>Hi,
>>
>>My log4plsql.tpl run with TOra.
>>
>>I am not on to have put the information in the check place
>>
>>Are all informations/doc is in end function or is possible
>>to add a doc in node place?
>>
>>In everything the cases, The integration has a big value added.
>>
>>--g
>>
>>
>>    
>>
>_______________________________________________
>Log4plsql-all-info mailing list
>Log...@li...
>https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
>log4plsq : http://log4plsql.sourceforge.net
>
>-------------------------------------------------------------------
>--
>--  Nom script         : TLOG
>--
>--  Objectif           : Generic tool of log in a Oracle database 
>--                       same prototype and functionality that log4j.  
>--                       http://jakarta.apache.org/log4j
>-------------------------------------------------------------------
>--
>-- History : who                 created     comment
>--     V0    Guillaume Moulard   18-AVR-02   Creation
>--                                     
>--
>-------------------------------------------------------------------
>/*
> * Copyright (C) LOG4PLSQL project team. All rights reserved.
> *
> * This software is published under the terms of the The LOG4PLSQL 
> * Software License, a copy of which has been included with this
> * distribution in the LICENSE.txt file.  
> * see: <http://log4plsql.sourceforge.net>  */
> 
> 
> 
>create or replace  view VLOG as 
>select '['||to_char(LDATE, 'DD/MM HH24:MI:SS')||':'||to_char(mod(LHSECS,100),'09')||']'||
>       '['||decode(llevel, 1,'OFF    ',
>                          2,'FATAL  ',
>                          3,'ERROR  ',
>                          4,'WARNING',
>                          5,'INFO   ',
>                          6,'DEBUG  ',
>                          7,'ALL' ,
>                          'UNDEFINED')||']['||
>       LUSER||']['||
>       LSECTION||']['||
>       LTEXTE||']' log
>from (select * from tlog where rownum < 25 order by id desc) 
>order by ID
>/
>
>
>
>
>-------------------------------------------------------------------
>-- End of document
>-------------------------------------------------------------------
>
>  
>