The get_object_source fails with my schema owner

[dehlers-cts]

I am getting an error when trying to view the source of a stored procedure. Everything else works great.
I have rights to see the source of the procedure:

[danielmeppiel]

@dehlers-cts can you please share the MCP server output from VSCode? From the control palette, list your mcp servers and select the Oracle MCP one, then Show Output. Then reproduce this and share the logs.

In addition, if you expand the "Ran get_object_source" call, we should be able to see what it is returning, if anything. This may give some hints!

[dehlers-cts]

2025-05-09 09:41:28.967 [info] Starting server oracle
2025-05-09 09:41:28.967 [info] Connection state: Starting
2025-05-09 09:41:28.967 [info] Starting server from LocalProcess extension host
2025-05-09 09:41:28.996 [info] Connection state: Starting
2025-05-09 09:41:28.997 [info] Connection state: Running
2025-05-09 09:41:31.135 [warning] [server stderr] FastMCP server initialized
2025-05-09 09:41:31.170 [warning] [server stderr] App Lifespan initialising
2025-05-09 09:41:31.170 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: ODPI-C 5.5.0
2025-05-09 09:41:31.172 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: debugging messages initialized at level 64
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: Context Parameters:
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: Oracle Client Config Dir: /opt/oracle/instantclient_23_7/network/admin
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: Environment Variables:
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: ORACLE_HOME => "/opt/oracle/instantclient_23_7"
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: LD_LIBRARY_PATH => "/opt/oracle/instantclient_23_7:"
2025-05-09 09:41:31.173 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: check ODPI-C module directory
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: ODPI-C module name is /app/.venv/lib/python3.12/site-packages/oracledb/thick_impl.cpython-312-x86_64-linux-gnu.so
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: load in dir /app/.venv/lib/python3.12/site-packages/oracledb
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: load with name /app/.venv/lib/python3.12/site-packages/oracledb/libclntsh.so
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: load by OS failure: /app/.venv/lib/python3.12/site-packages/oracledb/libclntsh.so: cannot open shared object file: No such file or directory
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: load with OS search heuristics
2025-05-09 09:41:31.174 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.169: load with name libclntsh.so
2025-05-09 09:41:31.183 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.181: load by OS successful
2025-05-09 09:41:31.183 [warning] [server stderr] ODPI [00005] 2025-05-09 16:41:31.181: validating loaded library
2025-05-09 09:41:31.196 [warning] [server stderr] Oracle Client initialized in thick mode
2025-05-09 09:41:31.196 [warning] [server stderr] Initialising database cache...
2025-05-09 09:41:32.034 [warning] [server stderr] Database connection pool initialized
2025-05-09 09:41:32.035 [warning] [server stderr] Getting list of all tables...
2025-05-09 09:41:32.408 [warning] [server stderr] Found 2 tables in the database
2025-05-09 09:41:32.408 [warning] [server stderr] Loading index in memory...
2025-05-09 09:41:32.408 [warning] [server stderr] Saving updated index to disk for schema: vision_ng_ai_schema_tool_2...
2025-05-09 09:41:32.409 [warning] [server stderr] Index saved!
2025-05-09 09:41:32.409 [warning] [server stderr] Cache ready!
2025-05-09 09:41:32.512 [info] Discovered 13 tools
2025-05-09 09:55:35.071 [warning] [server stderr] Lazily loading details for table HEARING...
2025-05-09 09:55:35.370 [warning] [server stderr] Saving updated index to disk for schema: vision_ng_ai_schema_tool_2...
2025-05-09 09:55:35.371 [warning] [server stderr] Index saved!
2025-05-09 10:02:19.757 [warning] [server stderr] Lazily loading details for table COURT_CASE...
2025-05-09 10:02:19.907 [warning] [server stderr] Saving updated index to disk for schema: vision_ng_ai_schema_tool_2...
2025-05-09 10:02:19.909 [warning] [server stderr] Index saved!