Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> what's wrong with this procedure?
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 - 17:46:13 CDT
![]() |
![]() |