search

loopbackio / loopback-connector-oracle

Connect Loopback to Oracle
http://loopback.io/doc/en/lb3/Oracle-connector.html
Other
28 stars 30 forks source link

ORA-00942: table or view does not exist errorNum: 942, offset: 92 #154

Closed gabe2code closed 6 years ago

gabe2code commented 6 years ago

I have seen this question in several post of internet an i try everithing to solve the problem. I verify if the table exist with plsql developer, check if I have SELECT permission for v_session. The table exist and belong's to the user. Inclusive i insert in to a table with a script for the initial data, but loopback functions always return that error. I reinstall the oracle, I don't know what else to do. Please help

dhmlau commented 6 years ago

@metallica666 , if you have tried to access the database using the same credentials set in the datasources.json, would it be because different schema names being used when connecting manually vs connecting using LoopBack?

gabe2code commented 6 years ago

Thanks for response @dhmlau , I solve the problem. The table ACL it wasn't create, so . I create the table with the script and all work perfectly

Mahm7oud commented 5 years ago

@metalgabe I facing same issue can you please let me know how can I solve it.

Thanks

gabe2code commented 5 years ago

@Mahm7oud Did you try to see if all the tables are properly created?

Mahm7oud commented 5 years ago

@gabe2code thank you for your interest, the table was created already .

gabe2code commented 5 years ago

@Mahm7oud can you please share some demo?, for me that was the key for solve the issue