-1

I'm currently working on a project utilizing sequelize-oracle and oracledb, and I've created two functions that work okay, but the delete function has some issues.

This deletion ran fine in Postman. Postman

Then, when I went to SQL Developer and executed 'SELECT * FROM users' I realized that return me 'table or view does not exist', but the table 'users' have 29 users registered...

SQL Table

I don't know why this doesn't work or why the table 'does not exist' if I have users into. The connection is fine, it isn't credentials errors because others functions are working fine in the same project.

Christian Baumann
  • 3,188
  • 3
  • 20
  • 37
Ignacio Cisternas
  • 3
  • 1

1 Answers1

1

It appears that the table was created using case-sensitive identifiers. That means that you'd need to use case-sensitive identifiers every time you reference the table or one of the columns

select "id", "username", ...
  from "users"

Generally, using case-sensitive identifiers is frowned upon as an architectural choice. It's generally pretty annoying to have to enclose every identifier in double quotes and to ensure that you're always using the same casing that was used to create the table & column.

Justin Cave
  • 227,342
  • 24
  • 367
  • 384