Re: Trigger for BLOB datatype

From: Shiv <shiv.hikumar_at_gmail.com>
Date: 2 Nov 2006 21:16:50 -0800
Message-ID: <1162531010.731286.219360@k70g2000cwa.googlegroups.com>

 Hi,
   The version is Oracle 9i.I am sorry to say that there was some mistake in mentioning my problem.There are two different problems at two different point of time.The first one is.......... I have two servers, server1 and server2.i want to create a trigger in a server1 for a table so that when there is any DML statement(say insert,delete or update) occur then that will fire and the data not the date will store in server2.It works fine in simple cases.but my table also contains a column of BLOB data type which stores image. Now the problem two is at some different point of time not related to

the above one.......................

When i am inserting the data that is image then we are first using empty BLOB and after that updating it.Is there any way to insert the image in only one step.
Thanks for your help.

   help me
    from

       shiv verma Received on Thu Nov 02 2006 - 23:16:50 CST