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!

execute immediate with for loop

733256Jun 3 2011 — edited Jun 3 2011
begin
for test_rec in (execute immediate ('select * from '||tab_name))
loop
dbms_out.put_line('1');
end loop;
end ;


it's return a oracle pre-difine error.the error code is ora-06550.
it's possible..if yes plzzz tell me how???
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2011
Added on Jun 3 2011
5 comments
3,060 views