specify what type of fields you have and what SQL is generated. I suppose we can find
a decision for your particular problem. Please compare results with standard Oracle
dbExpress driver.
2. You must pass table name without indicating schema to GetFieldNames. By default,
schema name coincides with user name. You can change schema name using
SQLConnection1.MetaData property.
Code: Select all
var
L: TStringList;
begin
L:=TStringList.Create;
try
SQLConnection1.Open;
SQLConnection1.MetaData.SetOption(eMetaSchemaName, LongInt(PChar('SYS')));
SQLConnection1.GetFieldNames('NLS_DATABASE_PARAMETERS', L);
finally
L.Free;
end;