Recent content by Halli

  1. H

    Make sure you have the 32 bits Oracle Client Installed

    Ok thanks for the reply, About Delphi tells me it's a 64bit version, but I will try to install the 32 bit Oracle thin client: kind regards Haraldur
  2. H

    Make sure you have the 32 bits Oracle Client Installed

    Hi, I have just set up my: a) Windows 10 64 bit b) Delphi Berlin v. 10.1 c) DOA components version 4.1 ( install doa41d101.exe ) d) An Oracle Instant Client 64 bits ( Thin client ). e) My PL/SQL Developer 64 bits = this software is working OK My problem: My Delphi project builds and runs ok...
  3. H

    Loadfromfile slow as Windows Service

    Hi, No, setting the param to true: m_LOB := TLOBLocator.CreateTemporary(pKerfi.Session, otBLOB, true ); does not change much... this command: m_lob.Write( m_LOBStream.Memory^, m_LOBStream.Size); still takes 4 to 6 sec to finish. Do you think that increasing the memory on the server...
  4. H

    Loadfromfile slow as Windows Service

    The reason why Im trying to put my blob file into TLoblocator is because later Im using this procedure: procedure TSkjBrefKerfi.SkjBrefUppfaeraBlob(PBrefNnr: Double; PBlob: TLOBLocator; const PMime: string); begin GetQuery; OCPQuery.DeclareVariable('P_BREF_NNR', otFloat)...
  5. H

    Loadfromfile slow as Windows Service

    Hi, I ran this code just now: m_LOB := TLOBLocator.CreateTemporary(pKerfi.Session, otBLOB, false ); m_LOBStream := TMemoryStream.Create; LogMessage(datetimetostr(Now) + ' TSkjalakerfi_service_doc_to_pdf TMemoryStream A LoadFromFile' , EVENTLOG_INFORMATION_TYPE, 0, 2)...
  6. H

    Loadfromfile slow as Windows Service

    Hi, thank you for your response. I tried: var m_LOB: TLOBLocator; m_LOBStream : TMemoryStream; begin m_LOB := TLOBLocator.CreateTemporary(pKerfi.Session, otBLOB, false ); m_LOBStream := TMemoryStream.Create; LogMessage(datetimetostr(Now) + ' TSkjalakerfi_service_doc_to_pdf...
  7. H

    Loadfromfile slow as Windows Service

    Hi, I've created a Windows Service in Delphi XE7 on my Windows 7 machine. The service converts docx to pdf like this: a) connects to oracle and checks if docx need to be converted b) finds a single docx and loads from database with: m_BLOB := TOracleQuery.LOBField('BFile')...
Back
Top