hi


Create or replace procedure abc(tname varchar2) as
TYPE DYNAMIC_CURSOR IS REF CURSOR;
refcur DYNAMIC_CURSOR;
rowcount number;
begin
Open refcur for 'select count(*) as cnt from '||tname;
Fetch refcur into rowcount;
dbms_output.put_line(rowcount);
end;

Dhanya M

-----Original Message-----
From: Jaiswal Milan (Path)
[mailto:oracledba-ezmlmshield-x59058785.[Email address protected]
Sent: Tuesday, November 02, 2004 9:34 PM
To: LazyDBA Discussion
Subject: Need Help [Ref Cursor]


Dear all
What is REF CURSOR ?

Regards,
Milan Jaiswal


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page