Author: Dev

PLS-00487 Invalid reference to variable Oracle SQL Error: PLS-00487 Invalid reference to variable Cause: A variable was referenced in a way that is inconsistent with its datatype. Solution: Check the spelling of the variable name. Make sure the variable was declared properly and that the declaration and reference are consistent regarding datatype. Example: DECLARE CURSOR…(Continue Reading)

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)