dbTalk Databases Forums  

Trigger for BLOB

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Trigger for BLOB in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Shiv
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.