|
-
problem with pl/sql tables
hi,
i am trying to insert a value in a pl/sql table inside a cursor. the code is as below:
create or replace procedure err_logging(p_owner varchar2)
--declare
--p_owner varchar2(20):= 'DRA';
is
TYPE rec_diff_cols IS table of varchar2(20)
index by binary_integer;
rec_cols rec_diff_cols;
j number := 1;
.
.
.
begin
..........
........
for i in cur_diff_cols_tab_mview(c_rec.dra_mview_name,c_rec.src_tblname)
loop
l_cols := i.column_name;
rec_cols(j) := l_cols;
--fetch cur_diff_cols_mview_tab into rec_cols;
j:=j+1;
end loop;
here when i am debugging the code i am getting this in TOAD...
undeclared identifier rec_cols..and no value is going into that I guess.
KIndly help ASAP.
regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|