ORA-06504: PL/SQL: Return types of Result Set variables or
query do not match



ORA-06504: PL/SQL: Return types of Result Set variables or query do not match..

Answer / guest

Cause: Number and/or types of columns in a query does not
match declared return type of a result set variable, or
declared types of two Result Set variables do not match.

Action: Change the program statement or declaration. Verify
what query the variable actually refers to during execution.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19806: cannot make duplex backups in recovery area

2 Answers  


ORA-12560: TNS:protocol adapter error

1 Answers  


ORA-01337: log file has a different compatibility version

1 Answers  


SQL*Loader-00113: Invalid silent mode option

1 Answers  


O2F-00315: An attribute of a type is listed twice in a type specification

1 Answers  






ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


ORA-28176: incorrect certificate version

1 Answers  


ORA-31429: subscription has not been activated

1 Answers  


PLS-00722: supertypes's AUTHID is different than subtype's AUTHID

1 Answers  


QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater

1 Answers  


ORA-30483: window functions are not allowed here

1 Answers  


ORA-16511: messaging error using ksrget

1 Answers  


Categories