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

RMAN-12014: multiple records for default channel configuration for string found in catalog

1 Answers  


NNO-00060: loading server topology from checkpoint file "string"

1 Answers  


ORA-02048: attempt to begin distributed transaction without logging on

1 Answers  


ORA-22059: buffer size [string] is too small - [string] is needed

1 Answers  


PCC-02110: DBMS=V6_CHAR is deprecated. Use CHAR_MAP=VARCHAR2, DBMS=V7 instead

1 Answers  






ORA-01244: unnamed datafile(s) added to controlfile by media recovery

1 Answers  


LPX-00106: attribute "~1S" of element "~2S" is undefined

1 Answers  


ORA-02324: more than one column in the SELECT list of THE subquery

1 Answers  


NNF-03002: Unknown BIND error code: string

1 Answers  


SQL*Loader-00557: unable to allocate memory

1 Answers  


ORA-09843: soacon: Archmon unable to create named pipe.

1 Answers  


RMAN-08109: channel string: restored block(s) from backup piece string

1 Answers  


Categories