Hi,
I'm probably missing something but I cannot find a workaround for this using VSC/SQLcl.
When my account password has expired I get the (expected) ORA-28001: the password has expired however the issue is that with both SQL Developer for VS Code or SQLcl (supplied with VS code or standalone, both 25.3) I cannot find a way to change the password.
In “legacy” SQL Developer I could/can right click on the connection and choose “Reset Password” and I'll be prompted for the old and new passwords and my account password will be updated on both the database and for the connection.
When using SQLcl I thought previously I had been prompted to change the password when it had expired, but this is not the behaviour I am seeing currently, it just exits with the error message as shown below.
❯ sql -name "Test OCI Cloud [testuser]"
SQLcl: Release 25.3 Production on Tue Oct 28 12:06:21 2025
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connection failed
USER = c##testuser
URL = Test OCI Cloud [testuser]
Error Message = ORA-28001: the password has expired
https://docs.oracle.com/error-help/db/ora-28001/
Currently I can work around this as I have legacy SQL Developer installed and shell access to the remote DB, but some of our developers only have SQL Developer for VSC or SQLcl without remote access requiring DBA input to change the password.
What am I missing, or is this a feature that can be implemented?
Thanks
Gareth