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


PLS-00360: cursor declaration without body needs return type



PLS-00360: cursor declaration without body needs return type..

Answer / guest

Cause: A cursor declaration lacks either a body (SELECT
statement) or a return type. If you want to separate a
cursor specification from its body, a return type must be
supplied, as in CURSOR c1 RETURN emp%ROWTYPE;

Action: Add a SELECT statement or return type to the cursor
declaration.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29324: SET COMPATIBILITY release string format is wrong

1 Answers  


EXP-00084: Unexpected DbmsJava error number at step number

1 Answers  


ORA-13384: error in network schema: string

1 Answers  


what is error treshold?

1 Answers  


ORA-23374: object group "string"."string" already exists

1 Answers  






ORA-00065: initialization of FIXED_DATE failed

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  


PCB-00211: VARYING not supported with PIC N or PIC G variable "string"

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  


ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string

1 Answers  


LPX-00411: unknown function name encountered

1 Answers  


ORA-19907: recovery time or SCN does not belong to recovered incarnation

1 Answers  






Categories