This has always been quoted as a problem in stored procs, so:
1) Is it safe to use triggers to copy blobs from one table to another

insert into another_table (id, b_lob)
values (new.Source_id, new.Source_b_lob)

Also, how painful is the corruption when it occurs in stored procs, does it
a) render the db useless
b) respond well to file-fix
c) is fine as long as you don't try and access the data?

I know this is 2 q's in one day, so thanks all.

JAC.