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

Home -> Community -> Usenet -> c.d.o.server -> Creating Stored Procedure in Oracle 7.3

Creating Stored Procedure in Oracle 7.3

From: Fabio <fabio_in_wawa_at_to_wez_wywal.poczta.fm>
Date: Mon, 27 Sep 2004 15:59:33 +0200
Message-ID: <MPG.1bc23b2067f5aee9896e1@news.interia.pl>


Hello,

what may be wrong with this procedure?

create or replace procedure easy.proc1_test as
begin
select sysdate from dual;
end;
/

Oracle SQL Worksheet always returns the following error when a stored procedure contains a simple SELECT statement:

MGR-00073: Warning: PROCEDURE EASY.PROC1_TEST created with compilation errors.

..:: fabio Received on Mon Sep 27 2004 - 08:59:33 CDT

Original text of this message

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