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 |
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Briefly explain what is literal? Give an example where it can be used?
Explain about your project and its relation to the current job position you are applying to?
What does a Control file Contain ?
how do get database name at sql prompt?
which statement is running fastly ie insert or delete?
how to insert data into partitioned table partition done by Range partition
if you ctreate table identity
What are the attributes that are found in a cursor?
How to define a procedure inside another procedure?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
How to use "out" parameter properly?