Recent content by Hugh.Jones

I need to load data into a separate schema from the one i am logged in as - using the path loader. I have qualified the TableName correctly with the Table Owner (OWNER.TABLE) but when I call the Prepare() method of the Loader I get an 'insufficient Privileges' message. The code works fine with...

I will experiment with that, but I dont think it would explain why some tables are working and others are not. (I am logging in as the table owner.) I have identified (and fixed) the problem. What I have found is that the FOraPathLoader.Prepare() does not guarantee the field order. You will...

This is getting very strange indeed, please if anyone can help with any suggestion - however wacky - I am beginning to lose faith. (thinking out loud - Is it possible I have a Threading issue ?) Consider the following fragment - (Same as last example but I have removed the *2 Datasize)...

Hi all. Seem to have hit a snag and I am really stuck .... I am porting from Interbase to Oracle using the direct path loader. Some, though not all, tables with blobs fail with ORA-01009. I have tried all sorts of combinations of buffer size and extra .DataSize to no avail. In my sample code...

I am happy - I passed OCIDLL="\oci.dll" on the commandline and that has worked.

IF I set the ORACLE_HOME to point to the 10g client, or the 11 instant I get the same message from InitOCI --------------------------- Debugger Exception Notification --------------------------- Project OraIBLoader.exe raised exception class Exception with message 'Initialization error Could...

Sorry - I should have said - this is a windoze client

I wrote and tested some Dataloader stuff using the Oracle 10g client. Now I come to deploy, I find that the target machine is Instant Client 11.1. I know this is not exactly an AA issue, but could you advise ? Oci.dll is clearly not present in its usual bin folder. It is not an option to...

I tried setting it at column level, and yes, the property value is retained, but it makes no difference. I have managed to get round the issue by issuing an ALTER SESSION - it is the NLS_TIMESTAMP_FORMAT parameter that works in this case. I can send you my source code if you want. let me know...

My Code ---- begin for Col := 0 to AIBTable.FieldCount - 1 do begin Size := 0; PBuf := nil; ThisField := AIBTable.Fields[Col]; if not ThisField.IsNull then begin case OracleDirectPathLoader1.Columns[Col].DataType of // Character or string field dpString...

Hi, all. I have been trying, without success, to get the Oracle Loader to load Timestamp fields from Interbase. It does not look to me as though the Loader's DateFormat makes any difference, but I guess I am missing something. Oracle shows NLS_DATE_FORMAT as DD-MON-RR Oracle Loader...