i need to create a procedure e.g
Create or replace procedure abc
...... and so on
if i need to call this procedure in a pl/sql block e.g.
cur c1 is select * from emp;
for rec in c1 loop
blah blah ...
my point is i need to dynamic this cursor_type ... whatever table I select in c1 i wouldn't change that abc procedure with cursor_type emp%rowtype to
dept%rowtype (if i am selecting from dept table in c1 cursor)... there must be something dynamic in it ... i hope i clear my point ...if anyone have any idea to solve it ....