Re: Trigger for BLOB datatype

Shiv schreef:

> 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

Did you try it? What error did you get?
Would the error not lead you to believe this cannot be done? I bet you get an ORA-22992...
Anyway, there are some workaround... See: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:950029833940 Received on Fri Nov 03 2006 - 02:55:17 CST