Re: Stored Procedures

In article <6EC14873F507D3119B8C0090273C4349061154_at_jdasoftware.com>,   Steven R Fuller <srfuller_at_doitnow.com> wrote:
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_000_01BF04B8.9E021676
> Content-Type: text/plain;
> charset="windows-1252"
>
> 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)

You need a semi-colon at the end of the insert statement.

> End Log_execution
> ;
>
> I get the message procedure compiled with multiple errors.

Type 'show 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????
>
> ------_=_NextPart_000_01BF04B8.9E021676
> Content-Type: text/x-vcard;
> name="srfuller.vcf"
> Content-Disposition: attachment;
> filename="srfuller.vcf"
> Content-Description: Card for Steven R Fuller
>
> 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
>
> ------_=_NextPart_000_01BF04B8.9E021676--
>
>

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