Re: truncating values on insert ?

From: DStevens <dstevens_at_navidec.com>
Date: Fri, 15 Feb 2002 08:48:25 -0700
Message-ID: <a4jak7$b4g$1@newsreader.mailgate.org>

Uhh... never mind, that didn't work!

SQL> desc test_table
 Name
Null? Type

---

• -------------------------------------------- NUMERIC_PK NOT NULL NUMBER(10,3) DATE_PK NOT NULL DATE VARCHAR_PK NOT NULL VARCHAR2(30) NUMERIC_ATTRIBUTE NUMBER(10,2) DATE_ATTRIBUTE DATE VARCHAR_ATTRIBUTE VARCHAR2(30)

SQL> Create or replace trigger x before insert on test_table for each row
  2 begin
  3 :new.VARCHAR_ATTRIBUTE := substr(:new.VARCHAR_ATTRIBUTE,1,30);   4 end;
  5 /

Trigger created.

Elapsed: 00:00:00.15

SQL>
SQL>
SQL> insert into test_table

values(1,sysdate,'x',2,sysdate,'12345678901234567890123456789012345'); insert into test_table
values(1,sysdate,'x',2,sysdate,'12345678901234567890123456789012345')

            *
ERROR at line 1:
ORA-01401: inserted value too large for column

Elapsed: 00:00:00.03

DStevens wrote:

> Perhaps a before insert for each row trigger would work?
>
> :new.field = substr(:new.field,1,20);
>
> "Jörg Jung" wrote:
>
> >
Received on Fri Feb 15 2002 - 09:48:25 CST