Hi Tom,

Thanks for all your previous help. I have another question to ask you. I need to create a procedure and show the display on
an ASP.

In the procedure I'm creating a cursor and selecting a few records from a table according to a certain criteria.

Declare
c1 cursor is select unit from case where unit like '2%';
c1_rec varchar2(05);
Begin
open c1;
loop
fetch c1 into c1_rec;
exit when c1%notfound;
dbms_output.put_line(c1_rec);
end loop;
close ci;
End;

This works fine on the SQL prompt, but I need to display the output as a table. How do I create a table to store these values and return this table as the out parameter in a procedure ?

I'm new to PL/SQL tables and somebody suggested to use that. How do I go about it ? I need to use %columntype instead of varchar2, number, etc. This is urgent !

Thanks is advance
Sudha