Re: what's wrong with this procedure?

SET SERVEROUTPUT ON
before you run the procedure. put_line procedure puts your text into SGA area. You need to retrieve it by using the above statement.

raghuvir

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:15:48 CDT