Home » Developer & Programmer » Forms » convert nvarchar2 to varchar2
convert nvarchar2 to varchar2 [message #86334] |
Wed, 22 September 2004 03:06  |
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
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Mar 05 00:21:33 CST 2025
|