Have a problem with users copy from Window apps and pasting into a
"note" field - VARCHAR2(2000). The problem is that ASCII codes such as
line feeds, tabs, etc are also copied and stored. When spooling to a
delimited text file or exporting data these ASCII codes (CODES 1-31
primarily) really can*things up.
Is there an ORA Utility or Update/Insert Trigger that I'm not aware of
that I can use? If not any suggestions or sample code.