Create procedure statement?
From: Jonathan A. Thompson <jont_at_digitalexp.com>
Date: Sun, 30 May 1999 14:37:29 GMT
Message-ID: <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...
Date: Sun, 30 May 1999 14:37:29 GMT
Message-ID: <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 Sun May 30 1999 - 16:37:29 CEST