 | |
Help S.O.S: How to return resultset from procedure and use it on c#
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Help S.O.S: How to return resultset from procedure and use it on c# -
01-14-2008
, 04:27 AM
#2
| |||
| |||
|
|
Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess. --This is my types package create or replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; --my procedure body create or replace PROCEDURE RETURN_RESULT_SET(ccc in out TYPES.cursor_type) is BEGIN open ccc for 'select * from PERSONEL'; END RETURN_RESULT_SET; --my c# commands OleDbCommand DbCommand = new OleDbCommand("RETURN_RESULT_SET", con); DbCommand.CommandType = CommandType.StoredProcedure; ...... OleDbDataReader myReader = DbCommand.ExecuteReader(); |
a whole slew of examples there on this.
Jim
#3
| |||
| |||
|
|
Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess. --This is my types package create or replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; --my procedure body create or replace PROCEDURE RETURN_RESULT_SET(ccc in out TYPES.cursor_type) is BEGIN open ccc for 'select * from PERSONEL'; END RETURN_RESULT_SET; --my c# commands OleDbCommand DbCommand = new OleDbCommand("RETURN_RESULT_SET", con); DbCommand.CommandType = CommandType.StoredProcedure; ...... OleDbDataReader myReader = DbCommand.ExecuteReader(); |
a whole slew of examples there on this.
Jim
#4
| |||
| |||
|
|
Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess. --This is my types package create or replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; --my procedure body create or replace PROCEDURE RETURN_RESULT_SET(ccc in out TYPES.cursor_type) is BEGIN open ccc for 'select * from PERSONEL'; END RETURN_RESULT_SET; --my c# commands OleDbCommand DbCommand = new OleDbCommand("RETURN_RESULT_SET", con); DbCommand.CommandType = CommandType.StoredProcedure; ...... OleDbDataReader myReader = DbCommand.ExecuteReader(); |
a whole slew of examples there on this.
Jim
#5
| |||
| |||
|
|
Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess. --This is my types package create or replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; --my procedure body create or replace PROCEDURE RETURN_RESULT_SET(ccc in out TYPES.cursor_type) is BEGIN open ccc for 'select * from PERSONEL'; END RETURN_RESULT_SET; --my c# commands OleDbCommand DbCommand = new OleDbCommand("RETURN_RESULT_SET", con); DbCommand.CommandType = CommandType.StoredProcedure; ...... OleDbDataReader myReader = DbCommand.ExecuteReader(); |
a whole slew of examples there on this.
Jim
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.