Search code examples
oracle-databaseproceduredbms-schedulerdbms-output

DMBS_OUTPUT --> DMBS_SCHEDULER

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

Solution

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