Most odd. It works standalone, but when in the context of your sample PL/SQL it does not. Logged.
On 01/08/2016 05:52 AM, Peter Lang wrote:
Picklist displaying functions but not procedures of a package
Thread created by Peter Lang
This one is weird. With the code below, only functions but not procedures of dbms_utility are displayed in the picklist dropdown.
CREATE PROCEDURE x AS BEGIN
FOR c IN ( SELECT 1 FROM dual WHERE dummy = ‘X’ ) LOOP
dbms_utility.| -- picklist displays functions, but not procedures
If I remove the WHERE clause, then the picklist is empty.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
this post as spam/abuse.