TORALoader Error - ORA-01747

[jdredd]

Have a oracle table that gets populated once a month from a data feed.
Been this way for a few years now with no changes.

Using the 9.4.12 update, along with Delphi 7.

After doing this update (and I think the update before at least), I can no longer
interact with this table structure. ORA-01747: invalid user.table.column, table.column, or column specification. I am sure this comes down to a few fields apparently use
some reserved names. I assume who ever created the table layout many years ago didn't realize, but in the same side, it hasn't been a big issue apparently either. The source
file had the header names that shouldnt have been used, that is probably where
that all came from.....

If I use Oracle's SQL Developer, I can dump our flat file source, directly to the table
no problem.

This is the table fields

Code: Select all

CHANGE
PCHANGE
STATUS
MFG
MAKE
MODEL
Y1
Y2
VARIABLES
PNAME
PLINK
VERIFYAPP
OEM
PTYPE
LONG
NOTES
SUPERSEDE
NEWDES
OEPRICE
ORIGIN
NEWORREBLT
CERT
PRICEDATE
OLDDES
OLDPRICE
LABOR
ID
CANADAPRICE
SIDE

If I use an older version of our program that was compiled with a much older
ODAC, it works fine.

Tried using the Oraloader call to pass by column # .. then by column name.. then by
column name with " " around conflicting field names like LONG ... but
no way around it.. other than to rename a few fields. LONG, CHANGE, ID, MODEL , I think
were the ones. Once Renamed them (putting a letter in front of them), it loads just
fine. Then have to go back and rename the fields again.

Currently not in a position to rename the table permanently as a few other departments
hit this data up and not in a position to have every one update their code for the
changes needed.

[AlexP]

hello,

For correct work with reserved word, you should set the QuoteNames property to True:

Code: Select all

OraLoader1.Options.QuoteNames := True;