Version 24.1.1
It seems that the login.sql that I have referenced in the extensions settings for SQL-DEVELOPER isn't being run.
I have tried:
- Uninstalling / reinstalling the extension
- Relative and direct paths for the login.sql (~/Oracle/login.sql vs /Users/dgault/Oracle/login.sql)
- deleting and recreating the login.sql itself.
- moving the login.sql to a new location.
Turning on TRACE level diagnostics doesn't make things any clearer. I see that the connection references the startupScript but it seems not to execute it.
Below is the login.sql script and the (elided) output from the log:
set define '^'
set serveroutput on size unlimited
set timing on
set pagesize 99
set linesize 132
{
"definition": {
"type": "ORACLE_BASIC",
"name": "[PUR-DEV]MY_USERNAME 🏠",
"host": "my.local.server",
"port": 1521,
"serviceName": "my_service_name",
"userName": "MY_USERNAME",
"userPassword": {
"valueType": "******",
"content": "******"
},
"links": [
{
"rel": "self",
"href": "http://localhost:52566/20221610/databases/connections/definitions/ZJ9y7sVpMlNAGzIW1wiW7Q"
}
]
},
"startupScript": "/Users/dgault/login.sql"
}
[6/13/2024, 8:24:03 AM] [DBToolsServerApp(65463)] [DEBUG] startupScript output:
[6/13/2024, 8:24:03 AM] [DBToolsServerApp(65463)] [DEBUG] HTTP/1.1 201 Created