if oracle store procedure returns pl/sql table or array then how could i read those things using ado.net.please guid me giving a small code and also
provide oracle store procedure.

You will want to look into the ADO.NET provider for Oracle for this information. Everything you need to handle Oracle databases should be available from it's methods and properties. The documentation will most likely contain as much information as you need to get started.

____________________________
My boss is a Jewish Carpenter (Jesus Christ)


Brain Bench Certified VB.NET Developer

There is a ADO.NET Data Provider for Oracle database that you can download and use. It is called OraDirect.NET . This provider works in a similar way to the SQl Provider and OLEDB Provider

Here is some information on OraDirect.NET
There are core classes that make up OraDirect .NET data provider. The following table describes those classes and their functions.

OracleConnection - Establishes a connection to Oracle database and can begin a transaction.

OracleCommand - Executes a SQL or PL/SQL statements and stored procedures at Oracle database, and exposes parameters.

OracleDataReader - Exposes and reads a forward-only stream of data from Oracle database.

OracleDataAdapter - Populates a DataSet and resolves updates with Oracle database.

OracleTransaction - Enables you to enlist commands in transactions at Oracle database.

OracleParameter - Defines input, output, and return value parameters for commands and stored procedures.
Along with the core classes listed in the preceding table,

OraDirect .NET data provider also contains the classes extending its base functionality and allowing to accomplish additional tasks.

OracleCommandBuilder - A helper object that will automatically generate command properties of

OracleDataAdapter or will derive parameter information from a stored procedure and populate the OracleParameter collection of OracleCommand object.

OracleDataTable - Provides all of the functionality needed to retrieve and manipulate data from Oracle server data source.

OracleScript - Servers to execute series of SQL statements separated by special symbols, like SQL*Plus scripts.

OracleLoader - Serves to load external data into the Oracle database.

OraclePackage - Provides access to packages stored in Oracle database.

OracleMonitor - Allows to monitor dynamic SQL execution in applications that use OraDirect .NET.

you can find more information from this link
http://crlab.com/oranet/

____________________________
BrainBench ADO.NET and ASP.NET Certified Developer