Re: INSERTING a BLOB through a VIEW --- problem

Unfortunately you cannot access large objects in a trigger. What you can do is call a stored procedure in an after insert trigger and insert the Blob, provided the Blob is 32k or less. If the Blob is greater than 32k than you can use a java stored procedure if you are using 8i. In versions previous to 8i it gets trickier but I believe you can acomplish essentially the same thing via an external procedure call.

HTH
RHC Tony wrote:
>
>
> I try to Insert a record with a BLOB (image) through a VIEW with an
 INSTEAD
> OF TRIGGER.
> The record is inserted but............. it does NOT insert the
> Blob-attribute.
>
> It does insert the blob when inserting directly into the table. (without
 the
> view and instead of.....)
>
> Why is that? Is it possible to overcome this problem ?
>
>
> Thankx in advance
> Tony
>
>
>
>
>

--
Posted via CNET Help.com
http://www.help.com/