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



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

Answer / guest

Cause: The INTO clause of a SELECT INTO statement was
omitted. For example, the code might look like SELECT
deptno, dname, loc FROM dept WHERE ... instead of SELECT
deptno, dname, loc INTO dept_rec FROM dept WHERE ... In
PL/SQL, only a subquery is written without an INTO clause.

Action: Add the required INTO clause.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08457: syntax error in SEPARATE CHARACTER option of SIGN clause

1 Answers  


RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers  


ORA-30483: window functions are not allowed here

1 Answers  


RMAN-06074: file string is not an ORACLE datafile

1 Answers  


ORA-16547: cannot disable the primary database

1 Answers  






DRG-12601: invalid user datastore procedure name: string

1 Answers  


ORA-29818: column name not properly specified

1 Answers  


PCC-00113: Value of DBMS option invalid with given value of MODE option

1 Answers  


ORA-12008: error in materialized view refresh path

1 Answers  


ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

1 Answers  


ORA-13275: spatial index creation failure on unsupported type

1 Answers  


ORA-30387: invalid rewrite mode for REWRITE_EQUIVALENCE API

1 Answers  


Categories