ExecuteArray Stored Procedure sample
Posted: Tue 23 Aug 2011 12:56
Hi,
Is there a sample using ExecuteArray with oracle Stored Procedure?
Is there a sample using ExecuteArray with oracle Stored Procedure?
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
// Create a command and set its type to 'StoredProcedure'.
OracleCommand cmd = new OracleCommand("insert_dept", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
// Create command parameters.
cmd.Parameters.Add(new OracleParameter("p0", OracleDbType.Integer));
cmd.Parameters.Add(new OracleParameter("p1", OracleDbType.VarChar));
// Bind arrays as parameter values.
cmd.Parameters["p0"].Value = new int[] { 50, 60, 70 };
cmd.Parameters["p1"].Value = new string[] { "Dept50", "Dept60", "Dept70" };
// Execute the command.
cmd.ExecuteArray(3);
Code: Select all
CREATE PROCEDURE insert_dept (p0 IN NUMBER, p1 IN VARCHAR2)
AS
BEGIN
INSERT INTO dept(deptno, dname) VALUES (p0, p1);
END;
CREATE TABLE dept (
deptno NUMBER(4) CONSTRAINT PK_DEPT PRIMARY KEY,
dname VARCHAR2(14) ,
loc VARCHAR2(13)
);