Oracle Client namespace

Question

I'm new to .Net using a Oracle backend. Up until now I've always used a SQL Server backend. I have several questions that I hope someone can answer and help me out. 1. What is a REF Cursor? 2. Do you have to use a Ref Cursor to bring back data from a stored procedure and populate a dataset? 3. Can someone show me code on how to call a stored procedure in a Oracle database utilizing the Oracle Client Namespace? Thanks In Advance ALR

alejandro.rivera · Answer

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....