Comments (4)
Can be reproduced with this program
// JCL_DEBUG_EXPERT_GENERATEJDBG OFF
program TestMormotOracle;
{$APPTYPE CONSOLE}
{$R *.res}
uses
System.SysUtils, SynDB, SynDBOracle, SynCommons;
procedure select;
var
P: TSQLDBOracleConnectionProperties;
It: ISQLDBRows;
I: Integer;
begin
P := TSQLDBOracleConnectionProperties.Create('93S010001AM_XE', '', 'pim', 'mypassword');
P.RowsPrefetchSize := 1024 * 1024;
P.BlobPrefetchSize := 1024 * 1024;
It := P.Execute(UnicodeStringToUtf8('select * from ext_wert_xxx'), []);
if It.ColumnCount > 0 then
begin
while It.Step do
begin
for I := 0 to It.ColumnCount - 1 do
begin
Write(', ');
if It.ColumnNull(I) then
Write('null')
else
Write(It.ColumnString(I));
end;
WriteLn;
end;
end;
It := nil;
FreeAndNil(P);
end;
var
I, J: Integer;
begin
try
for J := 0 to 2 do
begin
select();
end;
except
on E: Exception do
Writeln(E.ClassName, ': ', E.Message);
end;
end.
from mormot.
parameter # 10 is pin_duration for OCITypeByName
It's 0 there from the beginning and works for me with Oracle 9 - Oracle 19c.
What OCI version you use?
from mormot.
It is 11.2.0/11.2.1 64 bit. It seems to work fine in 32 bit.
from mormot.
Updated Mormot and everything works now.
from mormot.
Related Issues (20)
- Correct criticalsection managment and move some declaration to handle HttpAPI in Windows. HOT 2
- Memory Leak on RemoteDB HOT 2
- Documentation example mistake ? 4.3.1. TList-like properties HOT 10
- Endless recursive calls in SynCommons::FileSize HOT 3
- Typo in SAD 1.18 HOT 3
- why cannot run the same SQLite on Linux at the same time HOT 1
- Bufferoverread for THttpServerRequest.FullUrl HOT 4
- ARM9 without FPU(VFP) does not support HOT 1
- Forward slash instead of backslash? HOT 3
- Fatal Error (Exception External:?) after second exception in Interfaced based Services HOT 1
- Declaration of "ConvertToEmfPlus" is not 64 bit safe HOT 1
- THttpApiWebSocketConnection.PrivateData Property value cannot be set. HOT 2
- THttpServer.OnHttpRequest - Ctxt.RemoteIP is empty HOT 2
- HttpGet: outStatus parameter is invalid
- THttpServer : Executing the HEAD request will read the entire file HOT 4
- TWinHTTP Thread safe issue in filling OSVersionInfo HOT 1
- Postgresql boolean (t/f) JSON parsing HOT 1
- Cannot compile under Delphi 12 due to the compiler errors HOT 2
- SynBloomFilter large volumes HOT 1
- more than one results in AggregateDoc() - MongoDB HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mormot.