Handling password expiration

[epo]

Hi,

I try to implement the catching of warnings during the grace period. The code is the same as in the help but the ORA-28002 warning is not trapped (in fact the ExpirationMessage stay empty).

with OS_T do
begin
try
LogonUsername := user;
LogonPassword := pwd;
LogonDatabase := db;
LogOn;
// ORA-28002 (the password will expire within n days).
// ORA-28011 (the account will expire soon; change your password now).
if ExpirationMessage '' then
begin
// here connected !!
ShowMessage(ExpirationMessage);
// ask if the user want to change now the password
ChangePassword;
end
except
on E: EOracleError do
begin
if E.ErrorCode 28001 then
begin
...
end;
.....

Somebody has maybe an idea ? Serveur and client are 9.2.0.6.

Thanks,
Eddy

 

[epo]

Hi,

In fact, if the Options.UseOCI7 flag is set to false, it works !

Eddy

 

[Marco Kalter]

Why did you set UseOCI7 to True? This is just required if you have low-level compatibility issues with the Oracle client.

 

[epo]

Certainly an error . Probably when trying some code.