XE 23c error ORA-01480 on complex string variable, works on older databases

[Tailor K]

Hello

I am trying XE 23c, and using the normal PDB database with the standard CHARSET=AL32UTF8.

But I am setting Oracle.NoUnicodeSupport := True; due to same program working also with older databases on CHARSET=WE8MSWIN1252.

I sent you here a small sample that causes the problem.
View attachment Demo.zip

 

[Tailor K]

My mistake - even on older databases like 19c, if created as unicode format, fails too... didn't have right now a 18/12 with AL32UTF8 to test, but I believe would be the same problem.

 

[Tailor K]

Any thoughts on this ?
We would like to use unicode databases alongside the classic ones ... but that error will stop us from succeed.
It´s not feaseble to have dual programs for each database kind.

 

[Tailor K]

Hello
Any news here ? Is that error on demo program an Oracle failure or DOA bug ?