Arun,
There are two solutions .....
- plsql_table.DELETE will delete all rows.
- In the declare section, declare another pl/sql table of the same type
DECLARE
tbl_actual_table my_plsql_tab_type; -- this is your actual table
tbl_null my_plsql_tab_type; -- this is a null table, never to
be used
begin
- need to reset the plsql table ...
- first method ...
tbl_actual_Table.DELETE;
- or second method
tbl_actual_table := tbl_null; -- this might be little faster..
.... other code goes here ...
HTH
Raj
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Received on Wed Aug 09 2000 - 07:26:55 CDT