Re: Setting maximum size of a blob data type

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 17 Sep 2014 08:10:24 -0700
Message-ID: <1410966624.70139.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>

That won't work as you cannot call dbms_lob.getlength in a CHECK constraint:

SQL> create table temp_photo
  2 (

  3   ID    NUMBER(3)     NOT NULL,
  4   PHOTO_NAME         VARCHAR2(50),
  5   PHOTO       BLOB check(dbms_lob.getlength(photo) < 4097)

  6 );
 PHOTO BLOB check(dbms_lob.getlength(photo) < 4097)

                     *

ERROR at line 5:
ORA-00904: "DBMS_LOB"."GETLENGTH": invalid identifier

SQL> It was a good thought.  

David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"

On Wednesday, September 17, 2014 8:12 AM, Kim Berg Hansen <kibeha_at_gmail.com> wrote:  

Set a CHECK constraint on the length?

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Wed, Sep 17, 2014 at 4:01 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:

Is it possible to set a maximum size for a blob data type column?
>
>
>Jeffrey Beckstrom
>Lead Database Administrator
>Information Technology Department
>Greater Cleveland Regional Transit Authority
>1240 W. 6th Street
>Cleveland, Ohio 44113
>.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 17 2014 - 17:10:24 CEST