convert nvarchar2 to varchar [message #86333] |
Wed, 22 September 2004 02:42 |
Balaji
Messages: 102 Registered: October 2000
|
Senior Member |
|
|
Hi
I have a problem in compiling my procedure in forms. it is giving "Internal Error 1904" error while compiling. the problem is in a insert statement , that is selecting values from a table which has nvarchar2 datatype.
for example.
create table test (a varchar2(10);
create table test1(a nvarchar2(10);
insert into test (select * from test1)
the above insert statement gives "Internal error 1904"
if i change the test1 datatype to varchar2, it is compiling successfully. pls help
i tried converting the nvarchar2 to (to_char) and insert . still it is giving error.
Balaji
|
|
|