Devart Forums

Code: Select all

OracleUtils.OracleClientCompatible=true

Code: Select all

        OracleParameter curs_param = new OracleParameter("P#CURSOR", OracleDbType.Cursor) 
          { Direction = ParameterDirection.Output };
        cmd.Parameters.Add(curs_param);        
        cmd.ExecuteNonQuery();
        OracleDataReader rdr = curs_param.Value as OracleDataReader;

Code: Select all

OracleDataReader rdr = curs_param.Value as OracleDataReader;

Code: Select all

OracleDataReader rdr = ((OracleCursor)curs_param.Value).GetDataReader();

Code: Select all

create or replace procedure user.aaa(p#date_start date)is
begin
  null;
end;

Code: Select all

string server = "SERVER";
string user_name = "USER";
string password = "PASSWORD";
string connStr = "Persist Security Info=False;max pool size=1100;connection lifetime=3600;Number Mappings=((Integer,10,18,System.Int64),(Number,1,38,System.Decimal));User ID=" + user_name + ";Data Source=" + server + ";Password=" + password;
OracleConnection conn = new OracleConnection(connStr);
conn.Open();      
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "USER.AAA(TO_DATE('20061222 17:27:08', 'yyyymmdd HH24:mi:ss'))";
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();

Code: Select all

cmd.CommandText = "USER.AAA(TO_DATE('20061222', 'yyyymmdd'))";

Code: Select all

      OracleUtils.OracleClientCompatible = true;
      OracleConnection conn = new OracleConnection(connStr);
      conn.Open();
      OracleCommand cmd = conn.CreateCommand();
      cmd.CommandText = "select to_clob('111222') from dual";
      var rdr = cmd.ExecuteReader();
      rdr.Read();
      var lob = rdr.GetOracleLob(0);