Re: Creating Stored Procedure in Oracle 7.3

"Fabio" <fabio_in_wawa_at_to_wez_wywal.poczta.fm> wrote in message news:MPG.1bc23b2067f5aee9896e1_at_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

check the PL/SQL Guide, chapter 5 -- it will explain why you need to add an INTO clause to your select

if you were working in SQL*Plus, you could use the SHOW ERRORS command to see specific compilation error messages, in SQL Worksheet you'll need to select from the USER_ERRORS to see them

other issues you need to address:
[_] if possible get version 9i or 10g of oracle, 7.3 is very obsolete. if 7.3 is all you have for now (perhaps an existing learning environment?), at least get the 9i docs from http://tahiti.oracle.com so that you can become aware of current syntax and functionality

[_] you don't need to use a SELECT statement to get the value of SYSDATE, you can just assign it directly to a variable (see 'Assignments' in chapter 2 of the PL/SQL manual)

++ mcs Received on Mon Sep 27 2004 - 09:14:59 CDT