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-00290: operating system archival error occurred. See error below

1 Answers  


TNS-00208: Logging : string

1 Answers  


NZE-29009: Bad encrypted key length when using SSL 2.0

1 Answers  


SQL*Loader-00605: Non-data dependent ORACLE error occurred -- load discontinued.

2 Answers  


NNL-00513: Shows or sets the server's auto-refresh failure retry interval

1 Answers  






ORA-28165: proxy 'string' may not specify password-protected role 'string' for client 'string'

1 Answers  


RMAN-10009: error logging off of Oracle

1 Answers  


ORA-02050: transaction string rolled back, some remote DBs may be in-doubt

1 Answers  


RMAN-06745: skipping datafilecopy string; already backed up string time(s)

1 Answers  


IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


SQL*Loader-00939: OCI error while string for table string partition string

1 Answers  


NNL-00914: Forwarding desired on server queries: string

1 Answers  


Categories