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

Register Log In

Forums Products Direct Oracle Access XE 23c error ORA-01480 on complex string variable, works on older databases

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 Tailor K OP Member
OP Tailor K 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 Tailor K OP Member
OP Tailor K 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 Tailor K OP Member
OP Tailor K 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 Tailor K OP Member
OP Tailor K 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.059s Queries: 17 (0.017s) Memory: 2.5088 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-19 08:03:29 UTC
Valid HTML 5 and Valid CSS