Toad World® Forums

BUG: Can't see Package Procedures without Arguments from Scheduled Jobs

I’m using Toad version 12.8.0.49.

When adding / updating a Scheduled Job with a STORED_PROCEDURE Program Type, I can’t see Package Procedures without arguments.

This was reported for the Run Window here http://www.toadworld.com/products/toad-for-oracle/f/10/t/25093 and fixed in version 12.7 but is still a problem for the Scheduled Jobs window.

Spooling the SQL shows that the Scheduled Jobs window is incorrectly using only the ALL_ARGUMENTS view as follows and not also checking the DBA_PROCEDURES view:

select OBJECT_NAME || DECODE(OVERLOAD, NULL, NULL, ’ (’ || OVERLOAD || ‘)’)
from all_arguments
where owner = :open_mouth:
AND PACKAGE_NAME = :PN
AND POSITION = 1
AND SEQUENCE <= 1
ORDER BY OBJECT_NAME

Thanks Jeff. This is fixed for next beta.