SQL Performance (MOSC)

MOSC Banner

TCMS(3):PARSE ERROR: ospid=51121, error=6550 for statement: 2020-09-17T09:23:01.031224-04:00 TCMS(3)

edited Sep 17, 2020 1:32PM in SQL Performance (MOSC) 2 commentsAnswered

We have upgraded our DB from 12.1.0.2 to 19.8.0 recently. As we know 19c logs parse errors in alert logs. We also having cocnurrency because of failed parses. So we enabled more logging using trace events to know what exactly are failing. We see huge parse failures with error=6550. We thought ok something in wrong our custom code and checked there. Eventhough the function inside the procedure is being called with right arguments, we see parse failure like below(There is another param for that function(F_GET_MEMORIZE_SCHEDAPPT) called CSESSIONID which is missing when this function being called). So oracle just re-writing the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center