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
- 5274 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 |
What is indexing, and how does it improve performance?
can a view be updated?
What is a proxy class?
Does oracle charge for java?
How do we know whether an index is created on a table ???
How to return top 5 rows in oracle?
what is data abstraction
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the difference between alert log file and tarce file ?
When do you get a .pll extension in oracle? Explain its importance
Define oracle database
sql query to get zero records from a table
Oracle General 
