I’m using Toad version 188.8.131.52.
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 || ‘)’)
where owner =
AND PACKAGE_NAME = :PN
AND POSITION = 1
AND SEQUENCE <= 1
ORDER BY OBJECT_NAME