Re: what's wrong with this procedure?

Hi ,

Follow these steps:

1. At SQL prompt do this : SET SERVER OUTPUT ON
2. EXECUTE main;

Hope this Helps

Amarendra

Wei Weng wrote in message <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>_at_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 Fri May 29 1998 - 00:00:00 CEST