DMBS_OUTPUT --> DMBS_SCHEDULER

Question

I use a DBMS_OUTPUT.PUT_LINE('TEST') in a procedure to check every call of these procedure. The procedure is called by DBMS_SCHEDULER. job --> schedule every minute.

But there is no output on my DBMS_OUTPUT in my Developer. Log-Table listed perferct values : every minutes one job --> finished successful.

but why there is no output shown . Output is turned on. DB Oracle 11g

Michael

score 3 · Accepted Answer · answered Nov 21 '14 at 13:27

3

dbms_scheduler does not show dbms_output. The better ways is as you did: write to a table.

answered Nov 21 '14 at 13:27

score 1 · Answer 2 · answered Nov 21 '14 at 13:30

1

Either write your output to table like you already did or use UTL_FILE to ship it out to the DB server.

answered Nov 21 '14 at 13:30

mmmmmpie

2,908
1
18
26

score 1 · Answer 3 · answered Oct 23 '18 at 12:12

Although this may not be the best way to instrument your code, but starting from version 12c, dbms_output messages within dbms_scheduler jobs are stored and visible in USER|ALL|DBA_SCHEDULER_JOB_RUN_DETAILS views.

See https://docs.oracle.com/database/121/REFRN/GUID-E87CA539-38E8-41A4-B10B-784308A56F02.htm#REFRN20386 , columns ALL_SCHEDULER_JOB_RUN_DETAILS.OUTPUT and ALL_SCHEDULER_JOB_RUN_DETAILS.BINARY_OUTPUT

DMBS_OUTPUT --> DMBS_SCHEDULER

3 Answers3