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

Shiv wrote:
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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

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

Shiv schreef:

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Shiv schreef:

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...D:950029833940