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)