Re: Error while trying to INSERT RECORD -ORA-1400

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/17
Message-ID: <33a6e8f6.2416906@www.sigov.si>#1/1

On 16 Jun 97 05:06:43 GMT, "Cecil D'Souza" <cecil_at_total.net> wrote:

> [SNIP]
>begin
> v_bonus := v_bonus + bonus_in;
> insert into emp (comm)
> values (v_bonus)
>end;

Use UPDATE instead of INSERT.

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Tue Jun 17 1997 - 00:00:00 CDT