PLS-00362: invalid cursor return type; 'string' must be a
record type



PLS-00362: invalid cursor return type; 'string' must be a record type..

Answer / guest

Cause: In a cursor specification or REF CURSOR type
definition, a non- record type such as NUMBER or TABLE was
specified as the return type. This is not allowed. Only the
following return types are allowed: <record_type_name>
<record_name>%TYPE <table_name>%ROWTYPE
<cursor_name>%ROWTYPE <cursor_variable_name>%ROWTYTPE

Action: Revise the cursor specification or REF CURSOR type
definition so that it specifies one of the above return types.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15186: ASMLIB error function = [string], error = [string], mesg = [string]

1 Answers  


ORA-22342: dependent VARRAY column exceeds the maximum inline column size

1 Answers  


ORA-13040: failed to subdivide tile

1 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


ORA-10583: Can not recovery file string renamed as missing during test recovery

1 Answers  






NNL-00575: list_objects: list all objects in a domain or subtree

1 Answers  


ORA-30573: AUTO segment space management not valid for this type of tablespace

1 Answers  


ORA-19666: cannot do incremental restore of the controlfile

1 Answers  


RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby controlfile copies

1 Answers  


PLS-00923: native compilation failed: string:string

1 Answers  


KUP-04078: invalid file name specified: string

1 Answers  


ORA-24145: evaluation context string.string already exists

1 Answers  


Categories