Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error while fetching data

Rahul_IndiaApr 24 2014 — edited Apr 28 2014

I am trying to fetch the data from a cursor into the nested table .But i am getting the below error.

Error at line 15: PL/SQL: Statement ignored

create or replace procedure p1

is

cursor c1 is select ACCOUNT_NO from daily_amount  ;

type nest_tbl is table of NUMBER(24);

t1 nest_tbl;

begin

open c1;

loop

fetch c1 bulk collect into t1 ;

EXIT WHEN C1%NOTFOUND;

END LOOP;

close c1;

for i in 1..t1.count

loop

DBMS_output.put_line( T1(i).ACCOUNT_NO ); --- ERROR HERE ( Error at line 15: PL/SQL: Statement ignored )

end loop;

END;



This post has been answered by Moazzam on Apr 25 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2014
Added on Apr 24 2014
20 comments
2,460 views