NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR...
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
This only happens when I run by TOracleScript. example create a package, procedure or function that contains text with an accent.
OracleScript not detect ANSI text, to run the update the accents of the texts are exchanged, how can I solve?
AListScript.LoadFromFile('c:\atu.pdc');
AListScript.DefaultEncoding := TEncoding.ANSI;
OraScript := TOracleSession.Create(nil);
OraScript.Session := OracleSession...
This occurs when the component is released "OracleSession.free" eventually, log exception:
Exception:
Type: EArgumentOutOfRangeException
Message: Argument out of range.
My connection pool:
OracleSessionPool := TOracleSessionPool.Create(nil);
with OracleSessionPool do begin...
After enabling POOL started getting this message "Argument out of range" eventually, there any relation?
More information, some sessions are configured to "AutoCommit = True", this problem occurs when destroying the connection, return to the POOL.
It is recommended to use StatementCache in what situation?
What is the value recommended for StatementCacheSize?
StatementCacheSize is the size in bytes or queries?
My service runs many threads in tcp socket, after some time when I try to create a new connection can not, as if waiting another OracleSession connect infinitely, any suggestions?