Re: what's wrong with this procedure?

After creating the procedure in SQL*Plus, do the following:

SET SERVEROUTPUT ON
EXEC main;

Compiling and running stored procedures takes two steps: create procedure and exec. However, anonymous PL/SQL procedures are compiled and run at the same time.

Bill Bearden
Consultant

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 Thu May 28 1998 - 06:18:39 CDT