Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> what's wrong with this procedure?

what's wrong with this procedure?

From: Wei Weng <wweng_at_attila.stevens-tech.edu>
Date: 1998/05/24
Message-ID: <6ka7vl$cc3$1@apocalypse.dmi.stevens-tech.edu>#1/1

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 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US