Devart Forums

Code: Select all

<Property Name="ADDRESS_ID" Type="int64" Nullable="false" devart:DefaultValue="DDD_ADDRESS_ID.NEXTVAL" StoreGeneratedPattern="Identity" />

Code: Select all

DECLARE
  updatedRowid ROWID;
BEGIN
INSERT INTO AGTAPP.DDD_CONTACT(ROLE, FIRST_NAME, LAST_NAME, PHONE, MOBILE, FAX, EMAIL, QC_REPORT_CONTACT, LAST_UPDATED_BY)
VALUES (NULL, :p0, :p1, NULL, :p2, NULL, NULL, NULL, :p3)
RETURNING ROWID INTO updatedRowid;
OPEN :outParameter FOR SELECT DDD_CONTACT_ID, LAST_UPDATED_DATE FROM AGTAPP.DDD_CONTACT WHERE ROWID = updatedRowid;
END;

Code: Select all

            // Here we configure the EF-provider, so that the default values defined in the model are used 
            var config = OracleEntityProviderConfig.Instance;
            config.DmlOptions.InsertNullBehaviour = InsertNullBehaviour.InsertDefaultOrNull;

            _context = new DDDEntities();

Code: Select all

using (OracleConnection conn = new OracleConnection())
            {
                conn.ConnectionString = "replace with yours";
                OracleCommand cmd = new OracleCommand("PKG_SAMPLE.SP00GETLIST", conn);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                
                //cmd.Parameters.Add("P_CUSTOMERS", OracleDbType.Number).Value = new decimal[] { 1, 2, 3, 4 };
                //cmd.Parameters["P_CUSTOMERS"].ArrayLength = 4;

                conn.Open();

                OracleType numtype = OracleType.GetObjectType("NUMBERLIST", conn);
                OracleTable table = new OracleTable(numtype);
                table.Add(1);
                table.Add(2);
                table.Add(3);
                table.Add(4);
                cmd.Parameters.Add("P_CUSTOMERS", OracleDbType.Table).Value = table;

                IDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    Console.WriteLine(reader[1]);
                }
            }

Code: Select all

CREATE TYPE NumberList IS TABLE OF NUMBER;

CREATE OR REPLACE PACKAGE PKG_SAMPLE IS

  -- Author  : BHAVESHP
  -- Created : 05/05/2010 15:09:17
  -- Purpose : 

  -- Public type declarations
  TYPE T_CURSOR IS REF CURSOR;

  PROCEDURE SP00GETLIST(P_CUSTOMERS IN NUMBERLIST, CUR_OUT OUT T_CURSOR);

END PKG_SAMPLE;

CREATE OR REPLACE PACKAGE BODY PKG_SAMPLE IS
  PROCEDURE SP00GETLIST(P_CUSTOMERS IN NUMBERLIST, CUR_OUT OUT T_CURSOR) AS
  BEGIN
    OPEN CUR_OUT FOR
      SELECT *
        FROM CUSTOMER
       WHERE CUSTOMERID IN (SELECT * FROM TABLE(P_CUSTOMERS));
  
  END SP00GETLIST;
END PKG_SAMPLE;

-- Create table
create table CUSTOMER
(
  CUSTOMERID NUMBER,
  NAME       VARCHAR2(50)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

insert into customer (1, "sample 1");
insert into customer (2, "sample 2");
insert into customer (3, "sample 3");
insert into customer (4, "sample 4");