Author: Dev

ORA-01001: invalid cursor Oracle SQL Error: ORA-01001: invalid cursor Cause: Either a host language program call specified an invalid cursor or the value of the MAXOPENCURSORS option in the precompiler command were too small. All cursors must be opened using the OPEN call before being referenced in any of the following calls: SQL, DESCRIBE, NAME,…(Continue Reading)

PLS-00201 identifier must be declared Oracle SQL Error: PLS-00201 identifier must be declared Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role. Solution: Check your spelling and…(Continue Reading)

ORA-01031 insufficient privileges Oracle SQL Error: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. Solution: Ask the database administrator to perform the operation or grant the required privileges. Example: DELETE FROM SYS.ACCESS$; Output: SQL Error: ORA-01031: insufficient privileges

ORA-01033 ORACLE initialization or shutdown in progress Oracle SQL Error: ORA-01033 ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started or shut down. Solution: Wait a few minutes. Then retry the operation.

ORA-01017 invalid username/password; logon denied Oracle SQL Error: ORA-01017 invalid username/password; logon denied Cause: An invalid username or password was entered in an attempt to log on to Oracle. Solution: Enter a valid username and password combination in the correct format. Example: