Interested to Buy Any Domain ? << Click Here >> for more details...
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.......
- 1 Answers
- 5216 Views
- HCL, I also Faced
- E-Mail Answers
Answer / 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 |
how to find the n'th highest salary from emp ?
Why we use bulk collect in oracle?
How to use an explicit cursor without open statements?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Explain overloading. Can functions be overloaded?
How to create a server parameter file?
What is an Oracle index?
How to create an oracle database?
What is the simplest tool to run commands on oracle servers?
what is dynamic SGA and static SGA
defination of bitmap index
How to rename a column in an existing table?
Oracle General 
