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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger for BLOB datatype

Re: Trigger for BLOB datatype

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Nov 2006 08:58:12 -0800
Message-ID: <1162486690.711523@bubbleator.drizzle.com>


Shiv wrote:
> Hi,
> I have a problem.I have two servers, server1 and server2.i want to
> create a trigger in a server1 in a table so that when there is any DML
> statement(say insert) occur then that will fire and the date will
> store in server2.Till now every thing is fine but the problem is that
> table contains a column of BLOB data type which stores image.
> So plz, help me
> from
> shiv verma

What version of Oracle?

What problem? I don't see an Oracle error message in what you posted.

What code did you write? Post it.

I fail to see what relevance a BLOB column has with pushing a date to another server. You need to explain further what issue you are confronting.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 02 2006 - 10:58:12 CST

Original text of this message

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