Toad World® Forums

Picklist displaying functions but not procedures of a package

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.

Most odd. It works standalone, but when in the context of your sample PL/SQL it does not. Logged.

Thanks,

Michael

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.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

This one is annoying for me, any idea when you’ll get a chance to address this? Thanks!

This should be good to go in next beta.

Great, thanks!