TD51 + SP1 / Oracle 8: Mysterious error 10446

forum.gupta.bugreport (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

TD51 + SP1 / Oracle 8: Mysterious error 10446

Post by NewsgroupServer » 07 Feb 2008, 18:00

 Posted by:  Jaakko Terhonen 

Hello!

I have this SELECT command which I'm executing with SqlTalk:

select (replace(replace('bc_package.user_ident(''parm1,
parm2,parm3,parm4'')',' '),',',',:')) from dual;

and it works OK.

But when I add yet one REPLACE

select replace(replace(replace('bc_package.user_ident(''parm1,
parm2,parm3,parm4'')',' '),',',',:'),'(''','('':') from dual;

I get error

Error: 10446 SQL UBC Unicode conversion failed.

However when only the lastly added REPLACE is used:

select replace('bc_package.user_ident(''parm1,
parm2,parm3,parm4'')','(''','('':') from dual;

it works! What am I doing wrong?

Best regards,

Jaakko

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

TD51 + SP1 / Oracle 8: Mysterious error 10446

Post by NewsgroupServer » 07 Feb 2008, 19:02

 Posted by:  Jaakko Terhonen 

P.S. The quotas before and after the parameter list parm1, parm2 etc. are
not supposed to be there but anyway the problem is there.

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

TD51 + SP1 / Oracle 8: Mysterious error 10446

Post by NewsgroupServer » 12 Feb 2008, 13:59

 Posted by:  -pete- 

Hi,

This problem is said to be fixed with SP2 in end of February.
Defect number is: TD-4270
Error: 10446 SQL UBC Unicode conversion failed when client locale is not set
to UTF8

-pete-

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests