SQL & PL/SQL

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!

Unable to insert special symbols in table

msJul 8 2020 — edited Jul 14 2020

Hi All,

I have a special symbol (double dollar) in the line in a.txt file for e.g

0§EBBS§BH§20200520§20200520.ACCOUNT§20200520161733§ACCOUNT§

There is a stored procedure which reads the files from Unix server using utl_file and tries to insert into a table.

After executing the procedure, i am getting the result as below

0�BS��200520�200520.ACCOUNT�200520161733�COUNT

However when i insert s sample directly in sql developer for verification, i am able to insert the special symbol

insert into table1 values ('0§EBBS§BH§20200520§20200520.ACCOUNT§20200520161733§ACCOUNT§');

I have tried transferring the file in both "Text" mode and "Binary" mode in Winscp. Can someone kndly tell me why the special symbol is not being inserted as it is ?

Thanks

Gautam

Added on Jul 8 2020

26 comments

2,438 views