Search code examples
sqlnode.jsoracle11g

can't select data from oracle11g from nodejs - ORA-00942

I have a problem with getting data from oracle11g db from my nodejs, after I made a connection to my database, i'm trying to query it to get a values from 1 table but got this error ORA-00942, tryed several ways to select but still the same result

that's how I connect 

var oracledb = require('oracledb');  
oracledb.getConnection({  
   user: "MyUser",  
   password: "MyUserPass",  
   connectString: "localhost/Study"  
}, function(err, connection) {  
   if (err) {  
        console.error(err.message);  
        return;  
   }  
   connection.execute( "SELECT * FROM qt_date",  
   [],  
   function(err, result) {  
        if (err) {  
             console.error(err.message);  
             doRelease(connection);  
             return;  
        }  
        console.log(result.metaData);  
        console.log(result.rows);  
        doRelease(connection);  
   });  
});  

function doRelease(connection) {  
   connection.release(  
        function(err) {  
             if (err) {console.error(err.message);}  
        }  
   );  
}

and that's what i'm expecting to see

enter image description here

but all i got is error - ORA-00942: table or view does not exist

I tried several ways to select, similar to this one - select * from myUser.qt_date, but still got the same result

and also i thinks this problem is related to another one -

why do I have this undefined table in sql developere when i'm doing select but nothing like this when I'm inserting values ?enter image description here

thanks

Solution

  • I think I found a solution, I made a mistake and create my tables with "" around the name