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

Translate this page

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.

User Posts for PLS-00341

Be the first to post a message...

Post your own questions, answers and tips for PLS-00341

No registration required

CAPTCHA Image New word