Usage Note 19581: Oracle Password expiring may give Oracle prepare error
When your Oracle password is about to expire, you may encounter an error
in SAS similar to the following:
ERROR: ORACLE prepare error: . SQL statement: select count(*) from
account
You will also experience an error in SQLPLUS similar to the following:
ERROR: ORA-28002: the password will expire within 6 days
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Solaris for x64 | 9.1 TS1M3 SP4 | |
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
| Linux | 9.1 TS1M3 SP4 | |
| HP-UX IPF | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2008-03-05 16:24:30 |
| Date Created: | 2007-02-16 10:32:54 |