Re: what's wrong with this procedure?
From: Dave Wotton <Dave.Wotton_at_it.camcnty.no-spam.gov.uk>
Date: 1998/05/27
Message-ID: <6khdd6$lvc_at_dns.camcnty.gov.uk>#1/1
Date: 1998/05/27
Message-ID: <6khdd6$lvc_at_dns.camcnty.gov.uk>#1/1
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>_at_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.Received on Wed May 27 1998 - 00:00:00 CEST