Oracle password change using the Verify Password function

I am trying to write a Change password process to change user password on an Oracle 8i database with a Powerbuilder client. When the PL/SQL function supplied by Oracle (Verify Password) is enabled for the profile the Alter User username identified by newpassword fails with a ORA-20003 Verify password has failed.

The function works perfectly from a SQL editor such as Embarcadero's Rapid SQL.

I found one report that suggests using the OCIPasswordchange() function but appears to be very involved. Received on Wed Aug 20 2003 - 23:39:40 CEST