TOracleDirectPathLoader question

[rguillen]

Hi,
I'm using TOracleDirectPathLoader component and when I execute the sentence "Loader.prepare" I got the following error:
"ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges"

What privilege do I need assign to the user. The user is the object owner.

I'm using RAD Studio XE3 Enterprise 64 bits and Oracle 11g 11.2.0 Release 2.
DOA 4.1.3.3

Thanks

 

[Marco Kalter]

If you are connected as the owner then there are no privileges required.

 

[rguillen]

Hi Marco,
Thanks for your replay. It was solve, I was using different user than the owner.
But now I get the error: "ORA-01460: unimplemented or unreasonable conversion requested" when I try to execute the procedure Loader.Load(Row).

All fields on the table are varchar2

I fill the columns in this way
Loader.Columns[0].SetData(Row, @FileItemsDS.CrAccnt[1], Length(FileItemsDS.CrAccnt));
Loader.Columns[1].SetData(Row, @FileItemsDS.crCostCenter[1], Length(FileItemsDS.crCostCenter));
Loader.Columns[2].SetData(Row, @FileItemsDS.crLine[1], Length(FileItemsDS.crLine));
Loader.Columns[3].SetData(Row, @FileItemsDS.DrAccnt[1], Length(FileItemsDS.DrAccnt));
Loader.Columns[4].SetData(Row, @FileItemsDS.DrCostCenter[1], Length(FileItemsDS.DrCostCenter));
Loader.Columns[5].SetData(Row, @FileItemsDS.DrLine[1], Length(FileItemsDS.DrLine));
Loader.Columns[6].SetData(Row, @FileItemsDS.Amount[1], Length(FileItemsDS.Amount));
Loader.Columns[7].SetData(Row, @FileItemsDS.GLReference[1], Length(FileItemsDS.GLReference));
Loader.Columns[8].SetData(Row, @FileItemsDS.Sequence[1], Length(FileItemsDS.Sequence));
Loader.Columns[9].SetData(Row, @FileItemsDS.Transaction[1], Length(FileItemsDS.Transaction));
Loader.Columns[10].SetData(Row, @FileItemsDS.LineType[1], Length(FileItemsDS.LineType));

and this is the structure:
TFileItemDollarsSpent = class(TCollectionItem)
public
CrAccnt,
crCostCenter,
crLine,
DrAccnt,
DrCostCenter,
DrLine,
Amount,
GLReference,
Sequence,
Transaction,
LineType: string;
end;

Any idea about it?
Thanks.

 

[Marco Kalter]

Can you define the fields as AnsiString instead of String and try again? If it still fails, can you let me know the table definition?

 

[rguillen]

Hi Marco,
I have changed the fields definitions on Item Collection to AnsiString instead String and it works perfect.

Whit this approach I have improved the routine from process 48K rows in 3 hours to 163K in 9 minutes.

Thanks a lot.

 

[Marco Kalter]

That is a nice factor 20 improvement!