PLS-00341: declaration of cursor 'string' is incomplete or
malformed



PLS-00341: declaration of cursor 'string' is incomplete or malformed..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29838: insufficient privileges to execute the operator(s)

1 Answers  


PLS-00415: 'string' is an OUT parameter and cannot appear in a function

1 Answers  


PLS-00303: qualifier 'string' must be declared

1 Answers  


TNS-12639: Authentication service negotiation failed

1 Answers  


PLS-00166: bad format for date, time or timestamp literal

1 Answers  






RMAN-06405: database closed

1 Answers  


ORA-22607: image handle already generated

1 Answers  


QSM-01005: no query rewrite when query has slave SQL

1 Answers  


LPX-00216: invalid character ~1u (~2X)

1 Answers  


RMAN-04031: initialization parameters used for automatic instance: string

1 Answers  


ORA-38776: cannot begin flashback generation - flash recovery area is disabled

1 Answers  


ORA-09956: scgcm: unexpected lock status condition

1 Answers  


Categories