RE: HOW TO EXECUTE DELETE RECORD.

My best guess is that due to the language settings of the Oracle database (the completion message was provided in Spanish) and possibly your desktop/Toad language settings, hor is considered a reserved word.

Well.. as best I can get from web translations:

Fecha = date (a reserved word)
Hora = hour (I don’t think this is a reserved word, but could be wrong)

Perhaps Toad is having difficulties parsing – the Toad devs now need to reproduce the issue and see what’s what.

Roger S.

From: [email protected] [mailto:[email protected]] On Behalf Of Marvin Rios
Sent: Friday, March 09, 2012 11:28 AM
To: [email protected]
Subject: Re: [toad] HOW TO EXECUTE DELETE RECORD. [1 Attachment]


[Attachment(s) from Marvin Rios included below]
Yes in Toad send these errror  ORA-00904: "HOR": identificador no válido


Becouse?

Thank you

________________________________
From: "Simoneau, Roger" <[email protected]<mailto:[email protected]>>
To: "'[email protected]'" <[email protected]<mailto:[email protected]>>
Sent: Friday, March 9, 2012 11:33 AM
Subject: RE: [toad] HOW TO EXECUTE DELETE RECORD.


>> C:\>sqlplus
…
>> Procedimiento PL/SQL terminado correctamente.

It looks like it worked properly.  As Michael indicated, a best practice is to explicitly identify your date conversion… but if it had failed on that, it would be a different error then originally identified.

Marvin: does the proper execution of the procedure mean you can no longer duplicate the issue?  Or did you change the variable name hor to something else and it worked?

Or is there something we’re missing that you haven’t quite told us like: It works in sqlplus but gives the error in a Toad editor?

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.