santoshym,


This is what I get when running your script:


DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at line 18

Also, the syntax of the cursor is wrong. you have the 'order by' before the 'where'.

I appreciate the input. Thanks

[Edited by psychofun on 06-11-2002 at 10:18 AM]