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-28026: user with same external name already exists

1 Answers  


SQL-02120: First and second arguments to SQLRCN both null

1 Answers  


O2I-00126: You must specify an INTYPE file with SCHEMA_NAMES=FROM_INTYPE

1 Answers  


ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

1 Answers  


KUP-01006: error signalled during parse of access parameters

1 Answers  






ORA-02058: no prepared transaction found with ID string

1 Answers  


LPX-00213: comment did not end in "-->"

1 Answers  


TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


ORA-38950: Source platform string not cross platform compliant

1 Answers  


ORA-02034: speed bind not permitted

1 Answers  


ORA-00114: missing value for system parameter SERVICE_NAMES

1 Answers  


ORA-24094: invalid transformation, target type does not match that of the queue

1 Answers  


Categories