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.