Git Product home page Git Product logo

Comments (4)

tim-lebedkov avatar tim-lebedkov commented on June 5, 2024

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.

pavelmash avatar pavelmash commented on June 5, 2024

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.

tim-lebedkov avatar tim-lebedkov commented on June 5, 2024

It is 11.2.0/11.2.1 64 bit. It seems to work fine in 32 bit.

from mormot.

tim-lebedkov avatar tim-lebedkov commented on June 5, 2024

Updated Mormot and everything works now.

from mormot.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.