PLS-00362: invalid cursor return type; string must be a record type
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: lamp;lt;lamp;nbsp;record_type_namelamp;gt; lamp;lt;lamp;nbsp;record_namelamp;gt;%TYPE lamp;lt;lamp;nbsp;table_namelamp;gt;%ROWTYPE lamp;lt;lamp;nbsp;cursor_namelamp;gt;%ROWTYPE lamp;lt;lamp;nbsp;cursor_variable_namelamp;gt;%ROWTYTPE
Action: Revise the cursor specification or REF CURSOR type definition so that it specifies one of the above return types.
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: lamp;lt;lamp;nbsp;record_type_namelamp;gt; lamp;lt;lamp;nbsp;record_namelamp;gt;%TYPE lamp;lt;lamp;nbsp;table_namelamp;gt;%ROWTYPE lamp;lt;lamp;nbsp;cursor_namelamp;gt;%ROWTYPE lamp;lt;lamp;nbsp;cursor_variable_namelamp;gt;%ROWTYTPE
Action: Revise the cursor specification or REF CURSOR type definition so that it specifies one of the above return types.
No comments:
Post a Comment