Re: Create procedure statement?
Date: Mon, 31 May 1999 09:58:22 +0200
Message-ID: <7itfe3$bvk$1_at_zonnetje.NL.net>
Jonathan A. Thompson heeft geschreven in bericht
<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>
Jonathan,
seems you are doing most things wrong. What do you really want to do?
Describe what you are trying to achieve and I can (probably) give you a
better answer.
Frans
Received on Mon May 31 1999 - 09:58:22 CEST