Trigger for BLOB -
11-02-2006
, 11:21 PM
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 |