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...
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
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...
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 :=...