This forum is currently locked. You can't register or post questions at this time. (read more)

Logging Mechanism

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

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

Re: Logging Mechanism

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

Thanks Tim, I will go through these.

Regards

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 0 guests

cron