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

Home -> Community -> Usenet -> c.d.o.server -> Re: executing a query in a Stored Procedure

Re: executing a query in a Stored Procedure

From: Jarosław Palka <jarek_at_kamsoft.com.pl>
Date: Thu, 24 Jun 1999 10:54:11 +0200
Message-ID: <3771F233.98A4139F@kamsoft.com.pl>


> The PL/SQL syntax I used is as follows:
>
> Create Procedure GetInfo AS
> BEGIN
> select Field1 from MyTable;
> END;
>

You forgot about INTO clause.



Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice tel./fax (+48 32)255-59-93, 256-37-58, 256-46-50 POLAND Received on Thu Jun 24 1999 - 03:54:11 CDT

Original text of this message

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