Re: Create procedure statement?

From: Offsite Data Services - Support Analyst <support_at_dbmonitor.com>
Date: Fri, 25 Jun 1999 20:09:51 -0400
Message-ID: <VXUc3.35$vl2.2720_at_typ31b.nn.bcandid.com>


You have to
BEGIN
SELECT X
INTO Y ****This is the important part**** FROM Z;
END; Jonathan A. Thompson wrote in message
<01beaaaa$b11295a0$2a3f31cc_at_jonathan>...
>What am I doing wrong?
>I'm trying to create a stored proc as a select statement.
>Thanks in advance...
>
>SQL*Plus: Release 3.2.2.0.1 - Production on Sun May 30 10:41:07 1999
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>
>Connected to:
>Oracle7 Server Release 7.3.2.3.1 - Production Release
>With the distributed, replication and parallel query options
>PL/SQL Release 2.3.2.3.0 - Production
>
>SQL> CREATE PROCEDURE sp_test AS
> 2 SELECT user
> 3 FROM dual
> 4 /
>
>Warning: Procedure created with compilation errors.
>
>SQL>
>
Received on Sat Jun 26 1999 - 02:09:51 CEST

Original text of this message