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-12615: TNS:preempt error

1 Answers  


ORA-12223: TNS:internal limit restriction exceeded

1 Answers  


TNS-00073: * stop/abort - stop the process_name

1 Answers  


ORA-16093: dependent archive log destination is not LGWR-enabled

1 Answers  


NNO-00706: overriding next cache checkpoint, checking in number seconds

1 Answers  


DRG-50866: failed to resize string

1 Answers  


ORA-06794: TLI Driver: shadow process could not retrieve protocol info

1 Answers  


SQL-02131: Runtime context in use

2 Answers  


TNS-12684: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


NNL-00808: Queries received, all user-defined types: number

1 Answers  


ORA-02238: filename lists have different numbers of files

1 Answers  


ORA-27463: invalid program type string

1 Answers  


Categories