Stored Procedures

OK I am asking someone for help PLEASE..and no smart ass comments.

I created a procedure in Oracle8 as follows

Create OR Replace Procedure Log_execution Is
Begin
Insert into Log_Table
(user_id, sys_time)
VALUES(user_id, sysdate)
End Log_execution
;

I get the message procedure compiled with multiple errors.

Any body have any suggesstions. In longer procedures when I test the the individual
code blocks, the work effortlessly, when I try to create the procedures they fail????

Received on Tue Sep 21 1999 - 21:35:07 CDT