All,
Never mind...I figured it out. The problem wasn't coming from where I thought it was in the UPDATE statement into the VARCHAR2, but from another place in the code where this character data really was trying to be put into a numeric column.

Thanks,