RE: HOW TO EXECUTE DELETE RECORD.

Hey Marvin;

>> ORA-00904: "HOR": identificador no válido

Interesting puzzle.  The error message would indicate the column HOR is invalid.  The error seems quite misleading given HOR is a parameter for the procedure.

I created a table called hua_algorithm_hor using the columns identified and used it as both tables in the query, the procedure compiles and executes cleanly.

The tables listed are:
   Smart3g.hua_algorithm_hor
   Hua_algorithm_hor (if different from the schema specified above)
   Hua_algorithm_min

Perhaps describing the tables might give some clue as to what the issue is.

In the alternative, a test might be to change the input parameter hor to something else that couldn't possibly normally exist like zzzzxxyyyy and see if the error repeats.  Perhaps hor is some kind of reserved word.

It might be helpful to also identify the exact command you are running that generates the error.

My test was a simple: exec sp_hua_algorithm_hor(sysdate, 1);

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.