Package won't compile with strange characters
we are experiencing problems about compilation of a PLSQL package.
Compilation with plsqldev is good, but when we try to compile it in a business environment (with sqlplus related to DB) we get the following error and the "alter package compile body" fail:
NAME TYPE SEQUENCE LINE POSITION TEXT
------------------------------ ------------ ---------- ---------- ----------- ------------------------
PACKAGE_NAME PACKAGE 1 104 26 PLS-00103: Encountered the symbol "?" when expecting one of the following:
; is authid as under
The symbol "?" was ignored.
Line/Position is related to character "à" (accented a, asci 224). We have tried with "
ALTER SESSION SET NLS_LANGUAGE = Italian" but no good results. Our user, on unix system (aix6.2) running database (oracle 9i), is using LANG=en_US.