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-09960: Unable to establish signal handler for termination signal

1 Answers  


ORA-09759: osnsbt: bad message received.

1 Answers  


QSM-01093: anti-join marker not found in materialized join view

1 Answers  


ORA-30191: missing argument list

1 Answers  


DRG-11435: primary key value is invalid

1 Answers  






ORA-01688: unable to extend table string.string partition string by string in tablespace string

1 Answers  


ORA-26504: operation not implemented

1 Answers  


ORA-19777: ASM file string cannot be proxy backed up.

1 Answers  


ORA-16512: parameter exceeded maximum size limit

1 Answers  


NNL-00266: Round trip time is string

1 Answers  


DRG-11215: index owner does not have access to filter stored procedure: string

1 Answers  


ORA-22606: pickler image handle [string] is not well-formed

1 Answers  


Categories