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


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

SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


NZE-28855: Unsupported SSL operation

1 Answers  


PLS-00532: Target of REF must be a complete or incomplete object type.

1 Answers  


RMAN-20039: format requires character when duplexing

1 Answers  


PCB-00219: Invalid size specified in EXEC SQL VAR statement

1 Answers  






ORA-37115: New OLAP API history is not allowed

1 Answers  


ORA-09842: soacon: Archmon unable to create named pipe.

1 Answers  


DRG-12606: error encountered while parsing COLUMNS list

1 Answers  


QSM-01064: query has a fixed table or view

1 Answers  


ORA-19721: Cannot find datafile with absolute file number string in tablespace string

1 Answers  


ORA-14032: partition bound of partition number string is too high

1 Answers  


ORA-32738: Hang analysis aborted due to failed memory copy

1 Answers  






Categories