Unicode BOM Character In Export

[Scott Geiger]

I have found that when I export objects from PL/SQL Developer (using Tools > Export User Objects; File per Object/spec & body single file) that the exported files are prefixed with the Unicode BOM character. This does not appear when I view the file in Notepad++ on Windows. However, when I transfer the files to Linux and view them via VIM I see it as . When I then connect to Oracle (in Linux) and try to execute the file (e.g. @mypackage.pck) it causes errors because Oracle does not understand the BOM character. Does anyone have any ideas how to prevent this?

Thanks,
Scott G

 

[Marco Kalter]

I assume this is a Unicode database? If it does not contain any character data that is incompatible with your local character set, then you can go to Tools > Preferences > Oracle / Options and disable the "Unicode enabled" option.