Recent content by peterkloss

  1. P

    TOracleDirectPathLoader ORA-01009 with LONG Fieldtypes

    Here it is. You only need to create a new application with a BitBtn and a TOracleSession. QUESTION: Is it ok when I click on the "Default Columns" button in the TOracleDirectPath-Columns-Dialog that the fields are not sorted correctly? The LONG fields come after all others! (* CREATE...
  2. P

    TOracleDirectPathLoader with Date and Time

    It functions if Loader.DateFormat:= 'DD.MM.YYYY HH24:MI:SS'; is used instead of 'alter session set nls_date_format = ''DD.MM.YYYY HH24:MI:SS'''; Thanks for reply. :-) Peter
  3. P

    TOracleDirectPathLoader with Date and Time

    Using Delphi 7 and DOA 4.0.6.2 and Oracle 8.1.7 Cannot load date and time into one field. Only date is ok. Tried to alter nls_date_format with many different notations - but nothing helped. Source code: OracleQuery1.SQL.Text := 'alter session set nls_date_format = ''DD.MM.YYYY...
  4. P

    TOracleDirectPathLoader ORA-01009 with LONG Fieldtypes

    TOracleDirectPathLoader generally works fine, but when loading fields with type LONG then the Oracle error "ORA-01009 missing mandatory parameter" occurs. Delphi 7 and DOA 4.0.6.2 trial were used. Source code from the sample: Loader.Session := OracleSession1; Loader.TableName :=...
Back
Top