select user from dual

[RobNisbet]

Hi,

I am just testing my forms 6 app against a new 9i database (works fine on 8i).

I don't get far - the following simple proc
causes a ORA-24365 error (error in conversion of a multi-byte character)

This works OK in 8i, plus works OK in SQL*PLUS in 9i - so why does Forms not like it in 9i? Does 9i return the
user in a different type or something ?
any ideas would be great !
by the way, what the hell is a multi-byte character anyway and why is it being converted !
Thanks
Rob


PROCEDURE rob IS

v_username varchar2(1000);

BEGIN

SELECT user
INTO v_username
FROM dual;


end;

 

[sem]

What charset do you use in database? It may be due to newer charset on 9i not known for Forms. BTW is it 6 or 6i?

Regards, Dima

 

[RobNisbet]

I am using forms 6.0.5.34.0
unfortunately, charset is the same !

Cheers !

 

[sem]

Can you specify which one? This version of Forms uses 8.0.5 client that doesn't support Euro symbol.

Regards, Dima

 

[RobNisbet]

The 9i DB has charset WE8ISO8859P15 (Euro compliant),
whereas the old DB has WE8ISO8859P1, but I don't
see why this causes a problem since I am not using the
new characters, just selecting username from dual ??

Would the best solution be to upgrade Oracle client
to 9.2 ?

Thanks again
Rob

 

[sem]

It doesn't matter. If charsets are not convertable (even due to a single unused character) you can not work. You also can not upgrade client besides upgrading Forms. Try 6i, but I don't know whether it supports Euro.

Regards, Dima