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.......
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 |
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How does the on-delete-cascade statement work?
What is a proxy class?
What is an Index ? How it is implemented in Oracle Database ?
How to see free space of each tablespace?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
various types of hints and their usage
Give the various rollback segment states.
how to insert data into partitioned table partition done by Range partition
What is the difference between Outer join and Full outer join?
Explain what are the different type of segments?
Explain coalesce function?