Re: Stored Procedures

You need to use USER function in your VALUES clause. There is no such function user_id.

In article <37E8405B.ED1F616F_at_doitnow.com>,   Steven R Fuller <srfuller_at_doitnow.com> wrote:
> This is a multi-part message in MIME format.
> --------------224B6893A0E69A17C9F7062D
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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????
>
> --------------224B6893A0E69A17C9F7062D
> Content-Type: text/x-vcard; charset=us-ascii;
> name="srfuller.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Steven R Fuller
> Content-Disposition: attachment;
> filename="srfuller.vcf"
>
> begin:vcard
> n:;srfuller_at_doitnow.com
> x-mozilla-html:FALSE
> version:2.1
> email;internet:srfuller_at_doitnow.com
> x-mozilla-cpt:;0
> fn:srfuller_at_doitnow.com
> end:vcard
>
> --------------224B6893A0E69A17C9F7062D--
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 11:38:17 CDT