PL/SQL (MOSC)

MOSC Banner

Oracle 19c breaks mod_plsql for binding large arrays (flexible parameters) of your own type

edited Jan 19, 2022 9:23AM in PL/SQL (MOSC)

For what it's worth, I thought I'd share my last 3 days (and nights) of debugging this and coming up with the solution/workaround...

tl;dr; someone really messed up WPIUTL for mod_plsql. Remove the bug "fix" 26148849 and add the old code from 12c there instead, which removes the prefix for the logged on user - and you're good to go again.

Wallt-of-text:

If you use Oracle HTTP Server with mod_plsql, and upgrade your database to 19c, you'll encounter errors if using your own PL/SQL tables as in-parameters, like for (!)flexible parameters (name_array, value_array), and trying strings larger than 1499 characters.

Tagged:

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