RE: HOW TO EXECUTE DELETE RECORD.

>> differences in NLS_DATE_FORMAT
…
>> my bet is you won’t have the problem anymore

I’d actually be surprised if that fixed the particular issue identified.

The error wasn’t along the lines of “ORA-01843: not a valid month” which is the type of error one would expect during a bad run-time conversion on a date value.

It was “ORA-00904: “HOR”: invalid identifier”.  In the action of that error there is the phrase “It may not be a reserved word.”

Roger S.

________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.