I have a question about cursors.
I have the following sample code:
create table test_tableAA
(vchcola varchar2(10),vchcolb varchar2(10))
/
insert into test_tableAA values('aa','bb')
/
insert into test_tableAA values('cc','dd')
/
insert into test_tableAA values('ee','ff')
/
commit
/
declare
cursor test_curs is
select vchcola, vchcolb
from test_tableAA;
r_test test_curs%ROWTYPE;
L_vchcola varchar2(10);
L_vchcolb varchar2(10);
begin
dbms_output.put_line('Start');
open test_curs;
loop
fetch test_curs into r_test;
exit when test_curs%NOTFOUND;
L_vchcola := r_test.vchcola;
L_vchcolb := r_test.vchcolb;
dbms_output.put_line('L_vchcola='||L_vchcola||', L_vchcolb='||L_vchcolb);