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

RMAN-06456: command is obsolete

1 Answers  


ORA-02229: invalid SIZE option value

1 Answers  


ORA-25401: can not continue fetches

1 Answers  


LPX-00312: cannot construct XML PI with content: ~S

1 Answers  


ORA-25212: invalid PRIORITY specified when using sequence deviation

1 Answers  






ORA-38763: flashback not started; enabled threads have changed

1 Answers  


PCC-02040: CMD-LINE: Option selected, but no value provided

1 Answers  


NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


RMAN-06010: error while looking up datafile: string

1 Answers  


ORA-00311: cannot read header from archived log

1 Answers  


PLS-00400: different number of columns between cursor SELECT statement and return value

1 Answers  


SQL-02144: Invalid ANSI dynamic usage

1 Answers  


Categories