Code: Select all
var conn = new OracleConnection();
conn.Server = "XXX";
conn.Sid = "XXX";
conn.UserId = "XXX";
conn.Password = "XXX";
conn.Direct = true;
conn.Port = 1521;
conn.Open();
var cmd = conn.CreateCommand();
//cmd.CommandText = "select ROWIDTOCHAR( rowid ) as string from table
cmd.CommandText = "select rowid as string from table
var reader = cmd.ExecuteReader();
while (reader.Read())
{
string id = (string)reader.GetValue("string");
Console.WriteLine(id);
}
Console.ReadKey();
conn.Close(); Console.WriteLine("Hello World!");
AWfNF2AAFAABEQiAAM <- Expected RowID
AAfNF2AAFAABEQiAAM <- delivered RowID
With ROWIDTOCHAR all works right.
If i use Oracle.ManagedDataAccess, all things work fine.
My Devart Versions:
Devart.Data: 5.0.2806.0
Devart.Data.Oracle: 9.14.1382.0
Database Versions:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
"CORE 12.1.0.2.0 Production" 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Database Propertys:
DICT.BASE = 2
DEFAULT_TEMP_TABLESPACE = TEMP
DEFAULT_PERMANENT_TABLESPACE = USERS
DEFAULT_EDITION = ORA$BASE
Flashback Timestamp TimeZone = GMT
TDE_MASTER_KEY_ID =
DBTIMEZONE = +01:00
DST_UPGRADE_STATE = NONE
DST_PRIMARY_TT_VERSION = 18
DST_SECONDARY_TT_VERSION = 0
DEFAULT_TBS_TYPE = SMALLFILE
NLS_LANGUAGE = GERMAN
NLS_TERRITORY = GERMANY
NLS_CURRENCY = ?
NLS_ISO_CURRENCY = GERMANY
NLS_NUMERIC_CHARACTERS = ,.
NLS_CHARACTERSET = WE8ISO8859P15
NLS_CALENDAR = GREGORIAN
NLS_DATE_FORMAT = DD.MM.RR
NLS_DATE_LANGUAGE = GERMAN
NLS_SORT = GERMAN
NLS_TIME_FORMAT = HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT = DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT = HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT = DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY = ?
NLS_COMP = BINARY
NLS_LENGTH_SEMANTICS = BYTE
NLS_NCHAR_CONV_EXCP = FALSE
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_RDBMS_VERSION = 12.1.0.2.0
GLOBAL_DB_NAME = XXXXXX
EXPORT_VIEWS_VERSION = 8
WORKLOAD_CAPTURE_MODE =
WORKLOAD_REPLAY_MODE =
NO_USERID_VERIFIER_SALT = A130720AD78BFB3D344E21D7AEAD0D1F
MAX_STRING_SIZE = STANDARD
have a look also to:
viewtopic.php?f=1&t=39154&p=139863&hili ... id#p139863
Best regards