Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Why cannot perform select * within a proc
Using PO8. Get the following ERROR when performing the
following
Create or replace PROCEDURE USPS.SP_TEST
IS
BEGIN
select * from USPS.REPORTSELECT;
END PROCEDURE USPS.SP_TEST;
ERROR:
PLS-00428: an INTO clause is expected in this SELECT
statement
PL/SQL: SQL Statement ignored
Thanks in advance
![]() |
![]() |