Re: immutable LOBs

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 08 Jan 2005 03:02:46 GMT
Message-ID: <pan.2005.01.08.03.02.45.415354@sbcglobal.net>

On Thu, 06 Jan 2005 14:58:53 +0100, Volker Apelt wrote:

>
> Oracle 92i
>
> Is there any way to mark LOBs as read-only?
>
> How do you track changes to LOBs and trigger updates
> of meta data like MD5 sum?
>
> AFAIK, Triggers catch access to rows, but not DBMS_LOB.OPEN
> or .WRITE.
>
> Thanks,
>
> Volker

Volker, BFILE is what you need. You cannot modify it from PL/SQL.

-- 
Bug, noun: Son of a glitch

Received on Fri Jan 07 2005 - 21:02:46 CST