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

TNS-00225: Unable to bequeath connection to pump

1 Answers  


ORA-13428: invalid modelCoordinateLocation

1 Answers  


SQL-02124: NULL value returned by EXEC TOOLS statement

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


RMAN-07500: searching for all files that match the pattern string

1 Answers  


ORA-01288: file string is from a different database incarnation

1 Answers  


ORA-02246: missing EVENTS text

1 Answers  


ORA-16813: apply service not running on the apply instance string recorded by the broker

1 Answers  


ORA-39096: invalid input value string for parameter string

1 Answers  


PROC-00007: Cannot perform cluster registry operation because key handle is invalid.

1 Answers  


EXP-00081: Exporting access control for table/view "string" as non-DBA.

1 Answers  


RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


Categories