Skip to Main Content

Breadcrumb

May 4th

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)

Is this answer out of date? If it is, please let us know via 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 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