Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00210: cannot open the specified controlfile

1 Answers  


ORA-06023: NETASY: port open failure

1 Answers  


ORA-29867: cannot create a domain index on a LONG column

1 Answers  


DRG-10759: invalid role

1 Answers  


PCC-01005: PROCEDURE DIVISION not found

1 Answers  






DRG-50866: failed to resize string

1 Answers  


ORA-01264: Unable to create string file name

1 Answers  


ORA-13458: GeoRaster metadata SRS error

1 Answers  


ORA-12651: Encryption or data integrity algorithm unacceptable

1 Answers  


NCR-01020: NCRS: Operation would block.

1 Answers  


NZE-28874: SSL: I/O closed - override goodbye kiss

1 Answers  


DRG-11817: Proxy Redirect

1 Answers  






Categories