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-26711: remote table does not contain a primary key constraint

1 Answers  


ORA-16620: one or more databases could not be contacted for a delete operation

1 Answers  


PLS-00708: Pragma string must be declared in a package specification

1 Answers  


SQL*Loader-00276: Local storage option overrides global storage.

1 Answers  


QSM-01071: a lossy join in materialized view, string, from table, string, not found in query

1 Answers  


ORA-19692: missing creation stamp on piece string

1 Answers  


PCC-02383: Expecting an expression of type OCIExtProcContext

1 Answers  


TNS-00117: Internal error- No data passed through pump

1 Answers  


ORA-12353: secondary stored object cannot reference remote object

1 Answers  


TNS-01053: Connecting to string

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


ORA-32166: Cannot get XA connection

1 Answers  


Categories