"Unable to resolve column" for package level variables in PLSQL
Answered
Steps to reproduce:
1. create an sql file:
CREATE OR REPLACE PACKAGE test05 AS
TYPE test_record IS RECORD
(
col1 NVARCHAR2(1024)
);
type t_resulting_record_type is table of test_record;
t_1 t_resulting_record_type;
procedure p1;
END;
/
CREATE OR REPLACE PACKAGE BODY test05 AS
procedure p1 as
l_row test_record;
l_sql1 varchar(4096);
begin
l_sql1:='select ''a'' from dual';
execute immediate l_sql1 bulk collect into t_1;
for l_i in 1..t_1.COUNT loop
l_row :=t_1(l_i);
dbms_output.put_line(l_row.COL1);
end loop;
END p1;
end;
/
2. Compile using ctrl+Enter
3. Refresh using ctrl-f5
4. Observe that COUNT has error "unable to resolve column"
Please sign in to leave a comment.
yes looks like a bug. I've created issue on our tracker, please follow and vote to get noticed on any updates.