Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Why cannot perform select * within a proc

Why cannot perform select * within a proc

From: ggarrison <ggarrisonsr_at_hotmail.com>
Date: Thu, 24 Jun 1999 08:58:35 -0800
Message-ID: <930243516.29142@www.remarq.com>


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

Received on Thu Jun 24 1999 - 11:58:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US