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-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  


TNS-00297: Logging Level : string

1 Answers  


NNC-00431: NS address does not match any of the current addresses

1 Answers  


RMAN-03020: asynhronous RPC test will take 1 minute

1 Answers  


ORA-31044: Top-level prefix length string exceeds maximum string

1 Answers  






RMAN-06721: could not normalize path for file: "string"

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option

1 Answers  


ORA-23400: invalid materialized view name "string"

1 Answers  


ORA-39052: cannot specify SKIP_CURRENT on initial start of a job.

1 Answers  


ORA-07587: spdcr: $CREPRC failure

1 Answers  


ORA-600?

1 Answers   IBM,


Categories