ORA-06550: PLS-00428: an INTO clause is expected in this SELECT statement

ORA-06550: PLS-00428: an INTO clause is expected in this SELECT statement Oracle PL/SQL error message: ORA-06550: PLS-00428: an INTO clause is expected in this SELECT statement. Cause: A SELECT statement was executed without INTO clause in a PL/SQL block. Solution: Add the INTO clause to the SELECT statement. Example: DECLARE v_full_name VARCHAR2(500); BEGIN SELECT FIRST_NAME…(Continue Reading)

ORA-00984: column not allowed here

ORA-00984: column not allowed here Oracle PL/SQL error message: ORA-00984: column not allowed here. Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement. Solution: Check the syntax of the statement and use column names only where appropriate. Example: CREATE TABLE…(Continue Reading)

ORA-01416: two tables cannot be outer-joined to each other

ORA-01416: two tables cannot be outer-joined to each other Oracle PL/SQL error message: ORA-01416: two tables cannot be outer-joined to each other. Cause: Two tables in a join operation specified an outer join with respect to each other. If an outer join is specified on one of the tables in a join condition, it may…(Continue Reading)

ORA-01468: a predicate may reference only one outer-joined table

ORA-01468: a predicate may reference only one outer-joined table Oracle PL/SQL error message: ORA-01468: a predicate may reference only one outer-joined table. Cause: A predicate in the WHERE clause has two columns from different tables with “(+)”. Solution: Change the WHERE clause so that each predicate has a maximum of one outer-join table. Students table…(Continue Reading)

ORA-01427: single-row subquery returns more than one row

ORA-01427: single-row subquery returns more than one row Oracle PL/SQL error message: ORA-01427: single-row subquery returns more than one row. Cause: The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify values to compare because the subquery returned more than one row. Solution: Use ANY, ALL, IN, or…(Continue Reading)