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. 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/