originally entered by Sanjeev Chauhan ( chauh001 ) - 2009-08-27 13:36:33 CDT
When ILO_TASK.end_task is called in the exception handle section of a PL/SQL unit, the task does not get unset from the stack. This is also the case with call to ILO_TASK.end_all_tasks. As a result, ILO_TASK.get_task_stack return the task. The file ilo.log shows the step I used.
The problem only happens with the first job in the stack. If you add other
jobs to the stack, then all except the first one will be removed.
uname -a
SunOS ofs 5.10 Generic_118833-36 sun4u sparc SUNW,Sun-Fire-880
select banner from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production