Re: Stored proc problem

From: <deepak_c_at_my-dejanews.com>
Date: Tue, 28 Jul 1998 04:41:46 GMT
Message-ID: <6pjkqa$kks$1@nnrp1.dejanews.com>

Type SHOW ERRORS immediately after you run your script to create the procedure. SHOW ERRORS will pop you with the list of errors for the procedure which you have created. if your procedure has compilation errors, It will help you to understand the cause of error.

Also The statement SELECT * FROM MyTable; Used in your procedure is illegal, you can only SELECT into a variable.
for eg .
SELECT empname into mempname from empmast; Where mempname is a variable and must be declared beforehand.

Deepak Chebbi

In article <35b7b63d.0_at_informer.hixnet.co.za>, "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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 27 1998 - 23:41:46 CDT