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

Home -> Community -> Usenet -> c.d.o.server -> Re: The need to 'get around' the 4000 character limit in varchar2

Re: The need to 'get around' the 4000 character limit in varchar2

From: BD <robert.drea_at_gmail.com>
Date: 10 Nov 2006 11:00:02 -0800
Message-ID: <1163185202.665794.184590@i42g2000cwa.googlegroups.com>


> Perhaps you could get really ugly with multiple columns and joining
> them in a view then using a trigger to split out the data when it gets
> inserted/updated. But that's not where I would want to go.

I agree, it's a crappy solution.

The app in question was initially developed for SQL Server, and is being deployed against Oracle dbs - so this kind of 'retooling' is not at all unprecedented.

Thanks! Received on Fri Nov 10 2006 - 13:00:02 CST

Original text of this message

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