Re: Rookie question: "create procedure"

Erika Grondzakova wrote at 10-Mär-00 09:26:27 on the subject Re: Rookie question: "create procedure":

>Hello,
 

>What about...
 

>create or replace procedure getdate is
> my_date date;
> begin
> select sysdate into my_date from dual;
> dbms_output.put_line (my_date);
> end;

You can do this much simpler:

create or replace procedure getdate is
begin

   dbms_output.put_line(sysdate);
end;

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |