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

>