Hi All,
Apologies if this question is naive.
How to restrict the size of a BLOB column? I mean the column is defined as BLOB, and I want data not more than lets say 100KB to be in it, how to achieve this?
I believe you should be able to put a check constraint on the table that looks at the number of bytes in the column. You could certainly do this with a trigger, but the constraint makes more sense to me.
Justin Cave Justin Cave Distributed Database Consulting
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).