IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got ” ORA-06504: PL/SQL: Return types of Result Set variables or query do not match. ” error in Oracle database.
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match.
Details of error are as follows.
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match. 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.
PL/SQL: Return types of Result Set variables or query do not match
This ORA-06504 error is related to the 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.
Change the program statement or declaration. Verify what query the variable actually refers to during execution.
If you got this error when select column1,column2… from table, then use the select * from student table instead of few columns.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
