Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-02849: Read failed because of an error

1 Answers  


SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


ORA-07203: sltln: attempt to translate a long environment variable.

1 Answers  


ORA-06810: TLI Driver: could not set the IPX ethernet SAP at init

1 Answers  


TNS-01007: quit | exit : exit LSNRCTL

1 Answers  






ORA-12228: TNS:protocol adapter not loadable

1 Answers  


PLS-01414: Use of qualified expression here

1 Answers  


NCR-03023: NCRO: Cannot receive the break

1 Answers  


ORA-30990: insufficient privileges to change owner of resource string

1 Answers  


ORA-24318: call not allowed for scalar data types

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


ORA-09841: soacon: Name translation failure.

1 Answers  






Categories