Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 466 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to return a resultset using .Net SP

856576
Member Posts: 1
Hi,
I had a problem with using the .Net Stored Procedures.
How can i get the query resultset from a .Net SP?
DataSet and ref CURSOR doesn't work, because they can not be a parameter or return.
My Oracle is 10gR2,and I'm using Visual Studio 2005
Are there any ways to do that??
Thanks for your help!
Song
I had a problem with using the .Net Stored Procedures.
How can i get the query resultset from a .Net SP?
DataSet and ref CURSOR doesn't work, because they can not be a parameter or return.
My Oracle is 10gR2,and I'm using Visual Studio 2005
Are there any ways to do that??
Thanks for your help!
Song
Answers
-
If you use the Oracle Data Provider you have access to the RefCursor. BUT you do not need to access that in .NET. You can just FILL your Dataset from the Data Adapater. Here is some code...
//Call the procedure
OracleConnection cn = new OracleConnection(Classes.GeneralMethods.GetConnectionString("userid=xxxxxx");
OracleCommand cmd = new OracleCommand("pkg_ora_package.prc_get_my_data", cn);
cmd.CommandType = CommandType.StoredProcedure;
//Bind params by name and not by position.
cmd.BindByName = true;
cmd.Parameters.Add(OParm.GetOracleParameter("iv_acct_no", ParameterDirection.Input, iv_acct_no));
cmd.Parameters.Add(OParm.GetOracleParameter("ocsr", OracleDbType.RefCursor, ParameterDirection.Output));
DataSet ds = new DataSet();
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = cmd;
try
{
cn.Open();
da.Fill(ds); ///FILL THE DATASET
This discussion has been closed.