Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Stored proc problem

Stored proc problem

From: John Bester <johnb_at_iconnect.co.za>
Date: Thu, 23 Jul 1998 15:15:07 +0200
Message-ID: <35b7b63d.0@informer.hixnet.co.za>


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 Received on Thu Jul 23 1998 - 08:15:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US