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-00403: %s (string) is not the same as other instances (string)

1 Answers  


NNO-00701: warning: cannot construct checkpoint file name, checkpointing disabled

1 Answers  


PLS-00385: type mismatch found at 'string' in SELECT...INTO statement

1 Answers  


ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

1 Answers  


RMAN-06727: could not locate datafilecopy string

1 Answers  






QSM-00506: no fact-tables could be found

1 Answers  


RMAN-04003: ociinit failed

1 Answers  


ORA-06434: ssaio: read error, unable to read requested block from database file.

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  


PROT-00010: Failed to open the specified source cluster registry

1 Answers  


LFI-01003: Unable to read string bytes from file.

1 Answers  


Categories