When executing the SP, sometimes the following error appears:

SQL & gt; CALL MY_PROC ();
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.