0 I had a similar problem recently with Oracle 12c. I created a new user with a lower case password and was able to login fine from the database server but all clients failed with an ORA-01017. The fix …

That is: you want to the parameter name inside the query rather than concatenated with the string.

Nov 24, 2021 · ORA-01400: cannot insert NULL when inserting value into Oracle Database Asked 4 years, 5 months ago Modified 4 years, 5 months ago Viewed 7k times

May 18, 2015 · You may get ORA-01031: insufficient privileges instead of ORA-00942: table or view does not exist when you have at least one privilege on the table, but not the necessary privilege. …

ORA-06502: PL/SQL: numeric or value error: character string buffer too small Asked 12 years, 7 months ago Modified 5 years, 9 months ago Viewed 749k times

Jun 10, 2013 · ORA-01476: "divisor is equal to zero" for SQL query (Oracle 10g) Asked 12 years, 10 months ago Modified 12 years, 10 months ago Viewed 172k times

2 I faced the same issue while creating the connection on SQLDeveloper "ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist" Solution: 1.Update the listene.ora file to …

ORA-00060: deadlock detected while waiting for resource Asked 15 years, 10 months ago Modified 3 years, 4 months ago Viewed 203k times

ORA-01779: cannot modify a column which maps to a non key-preserved table Asked 12 years, 10 months ago Modified 5 years, 11 months ago Viewed 130k times

The result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on user1.customer table and is correctly prefixing the table with the schema owner …