Oracle Client namespace

Well thanks to everyone for there help - NOT!!! I still don't know what a Ref Cursor is or if in fact you need to use a ref cursor to populate a dataset. But here is some code to call a stored procedure and populate a dataset when using an oracle database. I hope this helps someone out who is trying to figure this out. ----------Store Procedure Code------------------------- CREATE OR REPLACE PACKAGE spk.TEST_ORACLEDATAADAPTER AS type refCursorxx is ref cursor; procedure getdata(a1 out refCursorxx); END TEST_ORACLEDATAADAPTER; CREATE OR REPLACE PACKAGE BODY spk.TEST_ORACLEDATAADAPTER AS procedure getdata(a1 out refCursorxx) is begin open a1 for select * from table1; end getdata; END TEST_ORACLEDATAADAPTER; ---------End of Stored Procedure------------------------------------ ---------C# Code ----------------------------------------------------- public void PopulateDataGrid() { try { OracleConnection Conn = new OracleConnection(ORACLE_CONNECTION_STRING); Conn.Open(); OracleCommand cmd = Conn.CreateCommand(); cmd.CommandText = "Campbell.Test_OracleDataAdapter.getdata"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new OracleParameter("a1", OracleType.Cursor)).Direction = parameterDirection.Output; DataSet dsGrid = new DataSet(); OracleDataAdapter adapter = new OracleDataAdapter(cmd); adapter.Fill(dsGrid); dataGrid1.DataSource = dsGrid.Tables[0]; } catch(Exception ex) { MessageBox.Show(ex.Message); } } -------------------END OF C# CODE-------------------------------------------- Can anyone tell me of a website that deals with .NET and an Oracle database backend because I haven't been able to find a site with sample code? All the sample code I see is for SQL Server. Thanks In Advance....