Re: what's wrong with this procedure?

Wei Weng <wweng_at_attila.stevens-tech.edu> wrote:

>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.

Hi,

you need to issue the SQL*Plus command:   

     set serveroutput on

in your session before you can see output from the dbms_output.put_line procedure. See the SQL*Plus manual for more options on this set command.

Dave.

-- 

To reply by email, remove the "no-spam" bit from my email address.