Quickly resolve Oracle Database errors with Oracle Doctor

Oracle Database Error PLS-00341

PLS-00341 declaration of cursor "string" is incomplete or malformed

Cause

A cursor declaration is improper or an identifier referenced in the cursor declaration was not properly declared. A return type that does not refer to an existing database table or a previously declared cursor or cursor variable might have been specified. For example, the following cursor declaration is illegal because c1 is not yet fully defined: CURSOR c1 RETURN c1%ROWTYPE IS SELECT ... -- illegal In this case, a return type does not have to be specified because it is implicit.

Action

Check the spelling and declaration of the cursor name and any identifiers referenced in the cursor declaration. Also confirm that the declaration is placed correctly in the block structure. If a return type was specified, make sure that it refers to an existing database table or a previously declared cursor or cursor variable.

PLS-00341 Comments

No comments yet

Submit comments and questions for PLS-00341

No registration required

CAPTCHA Image New word