we can't use execute immediate in for loop cursor.So,we can use ref

create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
IS
cmd varchar2(50);
begin
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
loop
dbms_output.put_line ( int.ename||' '||int.deptno);
end loop;
end;
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
one
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member
SUBMULTISET_
PLZ solve this error
give this question answer asap
Thanks advance.......

Question Posted / satish

1 Answers
5275 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / satish

we can't use execute immediate in for loop cursor.So,we can
use ref cursor instead of this to achieve this solution

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are advantages of dateset in datastage?

2309

How to get a create statement for an existing table?

1014

What exactly do quotation marks around the table name do?

1025

What are the execution control statements in oracle?

1131

How to convert characters to numbers in oracle?

1112

Explain what does a control file contain?

1165

How to connect to a remote server?

1189

How to start your 10g xe server from command line?

1127

How to view the tablespaces in the current database?

1026

Is insert autocommit in oracle?

1131

What is clustered table in Oracle?

1261

How do we display rows from the table without duplicates?

1017

What is the disadvantage of User defind function?

2341

What happens if recursive calls get out of control?

1139

What is different types of joins?

1078