Special Characters in Passwords

Hello,

  I have edited Oracle's standard verify_function created by utlpwdmg.sql to include the following special characters: ~ . ^ { } [ ] | \
  Password containing ~ or { or } work just fine. For the others, I receive the following error when trying to change my password using a command line:

SQL> password
Changing password for JBISCH
Old password:
New password:
Retype new password:
ERROR:
ORA-28003: password verification for the specified password failed ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Here is the piece of code that I altered from the verify_function:

   punctarray:='!"#$%&()~``*+,-/:;<=>?_{}\\.^|[]';

Could it be the order in which I have the characters are listed, or do I need to escape certain characters, or do these characters just not work for oracle passwords?

I am using Oracle 9.2.0.7 on Unix AIX 4.3.3. Any help would be appreciated.

Thanks,
Jeff Received on Wed May 30 2007 - 12:22:14 CDT