Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: what's wrong with this procedure?
You have created procedure. Now, type:
SQL> set serveroutput on
and then:
SQL> execute main
Regards,
Tanya
--
Tanya Injac
Oracle Developer/DBA
Unisys NZ Ltd
Wei Weng <wweng_at_attila.stevens-tech.edu> wrote in article
<6ka7vl$cc3$1_at_apocalypse.dmi.stevens-tech.edu>...
> Here is my little simple procedure:
>
> create or replace procedure main IS
> begin
> dbms_output.put_line(to_char(sysdate, 'MM/DD/YY'));
> End;
> /
>
> And i stored it in 1.sql. I ran it
> SQL>@1
> and it gave me
> Procedure created.
>
> But there is no output at all.
> Do I need to run it additionally?(if so, how?) Or there is something
wrong
> with the procedure I wrote?
>
> Thanks in advance.
>
> wei
>
Received on Sun May 24 1998 - 18:16:30 CDT