However, weak REF CURSOR types are more flexible because the compiler lets you associate a weakly typed cursor variable with any query.Declaring Cursor Variables After you define a REF CURSOR type, you can declare cursor variables of that type in any PL/SQL block or subprogram.