Hi,
I m using the BULK Collect in Oracle to improve the performance of my stored proc.
I dont know how to retrieve data from this stored proc in .net.
I am using C#.

I tried executing the stored proc using command.ExecuteReader.
It executes fine...But when I say while Reader.read(), it comes out of the loop. There is no data in the reader.

Regards,
--Monika

First your stored procedure must have select statement in the end.
In between do not execute select statement.
 set commandtext of your reader object to name of your stored procedure;
then add parameters to you reader object according to your procedure

reader.executereader()

while(dr.read())
//do you work

end while


urt