We recently upgrraded from 19c full client to 21c full client and sqlcl failed with this.
Error Message = no ocijdbc23 found in java.library.path:
But we found it worked fine with a 21c ic, and also the original 19c full client.
What I found odd is that sqlcl Release Notes going back at least through v24.3.1 (not 24.3 though) claim that the use of ORACLE_HOME for full client or instant client required client version 23ai.
We've never had 23ai installed, but 24.4 worked fine under the above conditions.
Are the Release Notes typically ‘off’ like this? Or or those ‘restrictions’ meant to convey that all features will only be available when using 23ai?
Thanks,
Mark