tag:blogger.com,1999:blog-2132893136140848212.post2277427153413309132..comments2023-09-09T03:03:30.219-06:00Comments on Martin Giffy D'Souza on Oracle APEX: Logger 2.0.0 AlphaMartin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2132893136140848212.post-45902510539680067382013-04-18T09:12:54.394-06:002013-04-18T09:12:54.394-06:00Hi Lev,
I plan to introduce something similar to ...Hi Lev,<br /><br />I plan to introduce something similar to log_params but for just a single parameter to be logged right away in a future release. This should resolve parsing the data as you described above.<br /><br />We can still look at exposing ok_to_log but we definitely want to discourage users from writing a lot of if/else blocks for logging.<br /><br />Thanks for clarifying things.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-45519060656194599572013-04-18T08:53:32.878-06:002013-04-18T08:53:32.878-06:00Hi Martin,
Thanks for feedback.
Developers don&#...Hi Martin,<br /><br />Thanks for feedback.<br /><br />Developers don't have to write bunch of if/else statements.<br />They can use logger.log_* procedures as they always used them.<br /><br />I think that logger.ok_to_log is for some special situations.<br /><br />For instance:<br /><br />v_date_from date;<br /><br />...<br />log.log('Date_from:'||to_char(v_date_from,'dd-mm-yyyy'));<br />...<br /><br /><br />Parameter of log.log(...) in this example 'Date_from:'||to_char(v_date_from,'dd-mm-yyyy') <br />to_char will be calculated even if logger_level is not 'DEBUG'.<br /><br />Sometimes (not always) it is better to write it like:<br /><br />v_date_from date;<br />...<br /> if logger.ok_to_log('DEBUG') then<br /> log.log('Date_from:'||to_char(v_date_from,'dd-mm-yyyy'));<br /> end if;<br />...<br /><br />Thanks,<br /> Lev<br />Levhttps://www.blogger.com/profile/07738586409100836666noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-55370812827231324112013-04-17T23:19:26.079-06:002013-04-17T23:19:26.079-06:00Hi Lev,
1- Let me think about it. I guess the goa...Hi Lev,<br /><br />1- Let me think about it. I guess the goal is to avoid developers having to write a bunch of "if/else" statements to log items. Just to be clear on your concern is parameter_value a value or a function? If it's a value what do you mean by "it still needs to be calculated"?<br /><br />2- I've received another request for this feature as well. I have added your request for the future release list. Odds are we could look at implementing it in a 2.1.0 release.<br /><br />Thanks for your feedback.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-15104860747820088772013-04-17T13:09:31.840-06:002013-04-17T13:09:31.840-06:00Hi Martin,
I think it's a very good idea.
Cou...Hi Martin,<br />I think it's a very good idea.<br /><br />Could I ask ask for 2 features - they are very easy to implement.<br /><br />1) Add function logger.ok_to_log to package spec<br /> This can make code more efficient.<br /><br /> For instance when I write code<br /><br /> logger.log(p_text=> Paramerter_Value() ...<br /><br /> Parameters are calculated even if they are not logged.<br /><br /> If function logger.ok_to_log was in package spec then I could write<br /><br /> if logger.ok_to_log('DEBUG') then<br /> logger.log(p_text=>Paramerter_Value()...<br /> end if;<br /><br />2) make primary key of new record inserted in logger_logs table available to user<br /><br /> Then I could sent e-mail to the user: <br /><br /> Your error is logged with id=....<br /><br /> When user calls support he will say that number and support will easily find <br /> error message.<br /><br /> Thanks,<br /> LevLevhttps://www.blogger.com/profile/07738586409100836666noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-44899442784073383972013-04-15T16:57:54.046-06:002013-04-15T16:57:54.046-06:00Excellent initiative Martin, look forward to the n...Excellent initiative Martin, look forward to the new version.Mark Lancasterhttps://www.blogger.com/profile/06316329564169609358noreply@blogger.com