Re: Stored Procedures

Hello

Try it this way and it works:

Create OR Replace Procedure Log_execution Is user_id log_table.user_id%type;
Begin
Insert into Log_Table
VALUES(user_id, sysdate);
End Log_execution
;

But where do you get the user_id ??

 Mario Bucsics

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!