PLS-00376 illegal EXIT statement it must appear inside a loop

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

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)