With the following code, code assist does not show packages/function/procedures below the query.
It works above the query, commenting out the query also makes it work again.
Can you reproduce this?
CREATE OR REPLACE PROCEDURE x AS v_dummy dual.dummy%TYPE; BEGIN SELECT dummy INTO v_dummy FROM dual; | END x;
This also happens with [22.214.171.1245]