Logging Mechanism

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Logging Mechanism

Postby ponic » Mon Sep 10, 2012 12:12 pm

Hi Tim,

I am looking for some kind of logging mechanism in our procedures and functions in order to trace out the errors and log these errors.
What is the best approach to achieve logging in plsql?

Thanks and regards
ponic
Senior Member
 
Posts: 160
Joined: Wed Mar 03, 2010 7:18 am

Re: Logging Mechanism

Postby Tim... » Mon Sep 10, 2012 12:59 pm

Hi.

There is not one "best" way to do this.

- Tom Kyte uses a package called "debug".
- Steve Feuerstein uses a package called "p".
- I use my own package called "DPS".
http://www.oracle-base.com/dba/miscellaneous/dsp.pks
http://www.oracle-base.com/dba/miscellaneous/dsp.pkb
- There is a project called log4plsql, similar to the Apache log4j project.

You should play around with them and see which you prefer.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Logging Mechanism

Postby ponic » Tue Sep 11, 2012 8:01 am

Thanks Tim, I will go through these.

Regards
ponic
Senior Member
 
Posts: 160
Joined: Wed Mar 03, 2010 7:18 am

Re: Logging Mechanism

Postby Tim... » Tue Sep 11, 2012 9:21 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 4 guests

cron