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-23361: materialized view "string" does not exist at master site

1 Answers  


QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)

1 Answers  


ORA-01545: rollback segment 'string' specified not available

1 Answers  


PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


ORA-24417: Session pool size has exceeded the maximum limit

1 Answers  






ORA-32330: invalid operation on online redefinition interim table "string"."string"

1 Answers  


ORA-26650: %s background process string might not be started successfully

1 Answers  


TNS-00003: INTCTL: error while sending request to the Interchange

1 Answers  


ORA-00364: cannot write header to new log member

1 Answers  


ORA-38450: error computing a stored attribute for the expression set.

1 Answers  


PCC-02436: This attribute is only valid for external LOB types (BFILEs)

1 Answers  


ORA-00203: using the wrong controlfiles

1 Answers  


Categories