Skip to Main Content

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Connor McDonald

Thanks for the question, ramakrishna.

Asked: October 14, 2006 - 3:53 pm UTC

Last updated: June 16, 2021 - 6:39 am UTC

Version: 9.2.0

Viewed 1000+ times

You Asked

HI Tom,

I am running one procedure using dbms_job.submit. but it is getting failed immediately. i wrote dbms_output command to output the error message. So how and where can I see that error message.

Thanks in advance for your great support...

and Tom said...

You cannot "see" that - it goes "nowhere". dbms_output will only work in "your session" and really only in sqlplus since you have to call dbms_output.enable to enable the output (and sqlplus does call that for you) and then the client has to know to retrieve this output and print it (and the job queues don't really have any place to "print" to)

</code> http://asktom.oracle.com/~tkyte/debugf 

Use utl_file or some sort of "logging table" to accomplish the instrumentation of your code.  Debugf is a utility I've used in the past, there is also
http://log4plsql.sourceforge.net/ <code>

Rating

  (2 ratings)

We're not taking comments currently, so please try again later if you want to add a comment.

Comments

debugf missing?

Gabriel Canton, November 28, 2006 - 2:01 pm UTC

Sorry Tom, the debugf link seems to be broken. Could you put it back?
Thanks!

Tom Kyte
November 28, 2006 - 7:51 pm UTC

</code> http://asktom.oracle.com/tkyte/debugf <code>

they turned off my user directory indexing :(

9i solution onwards

Duncan Brown, June 15, 2021 - 10:27 am UTC

As I came across this whilst looking for a solution in 12c, here is an update for anyone, albeit using the latest tools we now have access to .... https://connor-mcdonald.com/2016/06/27/dbms_output-and-the-scheduler/
Connor McDonald
June 16, 2021 - 6:39 am UTC

thanks for posting
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library