usql
usql copied to clipboard
Successully connecting but still getting error ORA-00942
I successfully connect to my local Oracle Database XE 21c, to the default PDB called XEPDB1. But, every time I connect, I get an error
Connected with driver oracle (<unknown, error: oracle: ORA-00942: table or view does not exist>)
To connect, I'm using this command: usql oracle://<user>:<pass>@localhost/xepdb1
I reproduced the same error by logging with a user that doesn't have read privilege on SYS.v$instance accessed by the Version function. PR #524 fixes this issue by reading the version from another view.