PL/SQL (MOSC)

MOSC Banner

dbms_lob.convertToBlob does not notifys warn_inconvertible_char correctly

edited Sep 11, 2023 10:00AM in PL/SQL (MOSC) 1 commentAnswered

Database 19c

Hello,

a CLOB defined in WE8MSWIN1252 charset has unsupported chars in US7ASCII charset. This Clob is converted by  dbms_lob.convertToBlob and the warning out parameter by this method should be dbms_lob.warn_inconvertible_char after executing this method. But it is not set to the expected value.

I attached my test script and i

n all cases the warning out parameter ist set to 0 meaning, there were no conversion error at all. But as you can see in the output, there are still unconvertable characters. Especially the case with the US7ASCII charset makes me wondering, how this case does not lead to an warning.

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