Print Thread
XE 23c error ORA-01480 on complex string variable, works on older databases
#64579 05/04/23 06:41 PM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
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.

Attached Files
Demo.zip (7.57 KB, 0 downloads)
SHA1: 4b9ba365cff6d51f7ed7845c00c1ce3db2be0415
Re: XE 23c error ORA-01480 on complex string variable, works on older databases
Tailor K #64580 05/04/23 06:50 PM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
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.

Re: XE 23c error ORA-01480 on complex string variable, works on older databases
Tailor K #64606 05/15/23 10:57 AM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
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.

Re: XE 23c error ORA-01480 on complex string variable, works on older databases
Tailor K #64744 08/02/23 05:00 PM
Joined: May 2005
Posts: 30
Member
OP Offline
Member
Joined: May 2005
Posts: 30
Hello
Any news here ? Is that error on demo program an Oracle failure or DOA bug ?


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.052s Queries: 16 (0.019s) Memory: 2.5108 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2024-07-17 12:41:51 UTC
Valid HTML 5 and Valid CSS