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

.

Relevant Pages

  • Special Characters in Passwords
    ... I have edited Oracle's standard verify_function created by ... Could it be the order in which I have the characters are listed, ... I need to escape certain characters, or do these characters just not ... work for oracle passwords? ...
    (comp.databases.oracle.server)
  • Re: Special Characters in Passwords
    ... I have edited Oracle's standard verify_function created by ... Could it be the order in which I have the characters are listed, ... I need to escape certain characters, or do these characters just not ... work for oracle passwords? ...
    (comp.databases.oracle.server)
  • Javac-compilor error
    ... discipline id.e.programming Java. ... from standard input and writes to standard output, but it is possible to redirect the input ... error occurs while trying to open the file, an exception of type IllegalArgumentException ... then this number of characters, then extra spaces are added to the front of x to bring ...
    (Fedora)
  • Re: PHP, mysql, and escaping characters
    ... MySQL requires only that backslash and the quote ... In addition to the qutoes, backslashes, and nulls, real escape string ... "Inserting a large value into a BLOB column is no different than ... a few characters that have special meaning in SQL or to the MySQL ...
    (comp.lang.php)
  • Re: Determine actual number of groups a user belongs to
    ... Dim intSecurity, intDistribution ... ' Escape any forward slash characters, "/", with the backslash ... All other characters that should be escaped are. ...
    (microsoft.public.windows.server.active_directory)