Toad World® Forums

Code Assist: Not displaying package/package functions in IN-clause

Not sure if you can fix this, but the second parameter of an IN-list does not behave the same way the first one does:

DECLARE
v_count PLS_INTEGER;
BEGIN
SELECT COUNT(*) INTO v_count FROM dual
WHERE 1 IN ( utl_tcp.bad_argument_errcode, | ); – no packages

SELECT COUNT(*) INTO v_count FROM dual
WHERE 1 IN ( utl_tcp.bad_argument_errcode, utl_tcp.| ); – no functions
END;

Seems to work with recent versions, thanks!