ORA-06550: line 3, column 1: PLS-00428: an INTO clause is expected.
854636May 4 2011 — edited May 11 2011hi experts,
on executing the following code i had th error like below.
the code which i am using(in pl sql region->source)
begin
SELECT
empno,
APEX_ITEM.HIDDEN(1,empno)||
APEX_ITEM.TEXT(2,ename) ename,
APEX_ITEM.TEXT(3,job) job,
mgr,
APEX_ITEM.DATE_POPUP(4,rownum,hiredate,'dd-mon-yyyy') hiredate,
APEX_ITEM.TEXT(5,sal) sal,
APEX_ITEM.TEXT(6,comm) comm,
deptno
FROM emp
ORDER BY 1;
end;
The error which i am facing
ORA-06550: line 3, column 1: PLS-00428: an INTO clause is expected in this SELECT statement