Author: Dev

PLS-00310 with %ROWTYPE attribute, must name a table, cursor or cursor-variable Oracle SQL Error: PLS-00310 with %ROWTYPE attribute, ‘string’ must name a table, cursor or cursor-variable Cause: The %ROWTYPE attribute must be applied to an identifier declared as a cursor, cursor variable, or database table. This error occurs when %ROWTYPE follows some identifier that has…(Continue Reading)

PLS-00206 %TYPE must be applied to a variable, column, field or attribute, not to Oracle SQL Error: PLS-00206 %TYPE must be applied to a variable, column, field or attribute, not to “string” Cause: The program object declared using the %TYPE datatype attribute is not of the appropriate class. It must be a variable, column, record…(Continue Reading)

PLS-00394 wrong number of values in the INTO list of a FETCH statement Oracle SQL Error: PLS-00394: wrong number of values in the INTO list of a FETCH statement Cause: The number of variables in the INTO clause of a FETCH statement does not match the number of columns in the cursor declaration. Solution: Change…(Continue Reading)

PLS-00376 illegal EXIT statement it must appear inside a loop Oracle SQL Error: PLS-00376: illegal EXIT/CONTINUE statement; it must appear inside a loop Cause: An EXIT statement was found outside of a loop construct. The EXIT statement is used to exit prematurely from a loop and so must always appear within a loop. Solution: Either…(Continue Reading)

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)