Home sql ORA-00936: missing expression ORA-06512: on

ORA-00936: missing expression ORA-06512: on




When executing the SP, sometimes the following error appears:

SQL & gt; CALL MY_PROC ();
ERROR at line 1:
ORA-00936: missing expression ORA-06512: on
"MY_USER.MY_PROC", line 22
ORA-06512: on "MY_USER.MY_PROC", line 192
ORA-06512: on "MY_USER.MY_PROC", line 224

Nothing special in the code:

192 update_val_proc (l_id, l_time, l_key, l_code, l_type, l_price, l_no);
193 loop_through_table_proc (327746);
224 write_log ('done.');

It is strange that on the same input data the HP sometimes works without errors, and sometimes gives this error. How can I display additional information about an error?

Answer 1, authority 100%

ORA-06512 is not actually an error, but a stack trace error message.

The error is ORA-00936 – as a rule, this is due to the fact that one of the fields takes the value null where it should not be.

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions