How to use N prefix at target code of procedure

User_8SY0K

I use Oracle Data Integration copy data from SQL server to Oracle.

My source database was SQLSERVER with Chinese encoding， and target was Oracle used Western.

I use procedure read source then write to target table was not recognized Chinese。

I try my SQL string at PLSql with N prefix at Chinese value, can be work, like:

insert into Material (BillDesc) values (N'金属')

My question is if I can replace the string with Procedure variable like :

insert into Material (BillDesc) values (N:Bill)

Rodrigo Radtke Souza

Yes, it should work. If : (binding) does not work, try #, like this:

insert into Material (BillDesc) values (N'#Bill')

Bill in this case is the name of the source column that you want to read.

Thanks!

Rodrigo Radtke Souza

Yes, it should work. If : (binding) does not work, try #, like this:

insert into Material (BillDesc) values (N'#Bill')

Bill in this case is the name of the source column that you want to read.

Thanks!

User_8SY0K

It's worked used # ,thank you very much!!