Re: Stored proc problem

On Thu, 23 Jul 1998 15:15:07 +0200, "John Bester" <johnb_at_iconnect.co.za> wrote:

>I have a problem creating a stored procedure in Oracle 7.3.
>
>CREATE OR REPLACE PROCEDURE Test AS
>BEGIN
> SELECT * FROM MyTable;
>END;
>/
>
>This gives an error "MGR-00072: Warning: PROCEDURE TEST created with
>compilation errors.", but it complies with the syntax found in the "Oracle7
>Server SQL Reference" (4-206). Can anyone help.
>
>Rgds
>--
>John Bester
>johnb_at_iconnect.co.za
>

Really ?????? John, where do you expect the resultant data from the select statement to go ??

What you need is......

Procedure X Is

v_name

Begin

   Select name
   Into v_name
  From table;
End;

Huwski

>
>
Received on Thu Jul 23 1998 - 08:31:48 CDT