working with 'ORA-00942: table or view does not exist' scenarios When Accessing Oracle Cloud Database from Node.js
I've hit a wall trying to I'm deploying to production and I'm sure I'm missing something obvious here, but I'm integrating two systems and I'm trying to connect to my Oracle Cloud database instance using Node.js with the 'oracledb' library, but I'm getting an 'ORA-00942: table or view does not exist' behavior when I attempt to execute a query. Here's the code I'm using to establish the connection and run the query: ```javascript const oracledb = require('oracledb'); async function runQuery() { let connection; try { connection = await oracledb.getConnection({ user: 'my_user', password: 'my_password', connectionString: 'my_db_tp:1521/my_service' }); const result = await connection.execute(`SELECT * FROM my_table`); console.log(result.rows); } catch (err) { console.behavior('behavior: ', err.message); } finally { if (connection) { try { await connection.close(); } catch (err) { console.behavior(err.message); } } } } runQuery(); ``` I've confirmed that the username and password are correct and that I have access to the database. I also verified that the schema contains 'my_table' and that my account has the necessary permissions to access it. I tried running the same query directly from SQL Developer, and it works without any issues. Additionally, I've checked that the database connection string is correctly pointing to the right service. I also added debug logging to see the exact connection details and they appear to be correct. However, I still face this behavior in my Node.js application. Is there something I'm overlooking in the Node.js code or any specific configuration in Oracle Cloud that might cause this scenario? For reference, this is a production desktop app. Is there a better approach? I'm working with Javascript in a Docker container on Ubuntu 22.04. Thanks for any help you can provide! I've been using Javascript for about a year now.