PL/SQL Documentation info

In a scheduler task it is possible to generate extra task info during execution of the script procedure.
The task info is displayed on the task properties window (task panel) and can be queried with the database view SO_VW_TASKS.

Screenshot PL/SQL scheduler window W25 Task properties (task panel) Back to top 

Create task info

The procedure SO_RUN.TASK_INFO must be called in the script procedure that is executed.

procedure task_info(
    p_task_info in varchar2 default null);
  
Parameter Description
p_task_info Runtime scheduler task info.
Error Description
OSC-10065
SCHEDULER FUNCTIONALITY CAN ONLY BE USED WITHIN A RUNNING TASK
Back to top