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-28301: Domain Policy hasn't been registered for SSL authentication.

1 Answers  


RMAN-06027: no archive logs found that match specification

1 Answers  


ORA-16043: managed recovery session canceled

1 Answers  


ORA-30177: invalid flag used in a format specification

1 Answers  


ORA-00382: %s not a valid block size, valid range [string..string]

1 Answers  






ORA-30204: buffer is not large enougth

1 Answers  


PCC-02435: This attribute is only valid for internal LOB types

1 Answers  


IMP-00046: using FILESIZE value from export file of string

1 Answers  


NZE-28858: SSL protocol error

1 Answers  


TNS-01157: Can only listen on number addresses - ignoring string

1 Answers  


ORA-19703: device command string exceeds maximum length of string

1 Answers  


TNS-01027: Listener Trace File string

1 Answers  


Categories