Forum Stats

  • 3,757,055 Users
  • 2,251,192 Discussions
  • 7,869,716 Comments

Discussions

How to use N prefix at target code of procedure

User_8SY0K
User_8SY0K Member Posts: 5 Red Ribbon

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)

Tagged:

Best Answer

Answers