Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use N prefix at target code of procedure

Meng KrisJul 1 2021

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)

This post has been answered by Rodrigo Radtke Souza on Jul 1 2021
Jump to Answer

Comments

Processing