Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: I need a trigger to automatically extend the length of a column.

Re: I need a trigger to automatically extend the length of a column.

From: Ing. Klaus-Michael Hatzinger <zing_at_memo.ikea.com>
Date: 1998/03/10
Message-ID: <6e3nl9$ffs$1@mailgate.ikea.com>#1/1

Hi Michael !

I think this will never work with oracle. One reason is, that you want to fire a DDL statement in a table trigger during an transaction and DDL statements issue an implicit commit - so it isn't allowed, even if you use dynamic SQL.

Why don't you create your column as a VARCHAR2 field with the maximum length that can occure. You don't waste unneeded space with this method.

br, Michael Hatzinger
IKEA-Business Services
AUSTRIA Michael MacDonald wrote in message <6e1hf9$l6d$1_at_newsfeed2.ftn.net>...
>I need a trigger that will automatically extend the length of a column in a
>table
>before data is inserted which would otherwise fail due to column size
>restriction.
>
Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US