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?
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;

 

[gazal]

try this not sure but can work....
SELECT "user"
INTO v_username
FROM dual;


gazal

 

[RobNisbet]

Thanks, but sorted now - it was the characterset in 9i not supported. We are moving to 6i which works OK!

 

[kthompsn]

Believe the multi-byte character refers to the fact that some languages (mainly non-european?) have more characters than can be represented in the normal ASCII or EBCDIC code ranges. So some hex values are designated as "prefix" codes, and can be followed by up to 254(?) values, to allow more than 255 unique characters. At least, that's how the IBM mainframe DBCS (double-byte character sets) were explained to me, many years ago. HTH.