pls tell me how can i interact with oracle database in c#
How to fill datset with oracle stored procedure?
SP may take some parameters and will have select statement.
as far as i know ,it will not be as easy as we do in SQL SPs
It will need to write package.
can anybody pls explain this with example?

This can be done the sane way as it for SQl Server

It would be nice that you use System.Data.Oledb.

Vivek Shah