SEO

I have a probable need to exchange blobs between an Oracle database
(which I don't control) and an ASE 12.0.0.4 database which I do
control. These databases are on different servers that are not
colocated. The blobs represent "attachments" to a particular "header"
record in the database, and could be in the form of text, image,
MSWord, spread sheet, etc., etc., etc. As I understand it, Oracle 9.i
handles this through a db extension that stores information about what
type of attachment is being stored in the blob and allowing the blob to
be opened "gracefully". I have not used blobs in ASE, so I'm not aware
of any potential difficulties from the ASE side.

My inclination is to institute an Oracle to ASE replication flow and to
let the respective engines take care of moving the stuff about the
network(s). At this point in time, I believe that ASE will not need to
ship the attachments back to Oracle, nor to perform modifications on
the attachments once we have captured them on our server/in our DB.

Can someone name the Sybase product(s) that we would need to accomplish
this replication?

Are there any 'heads-up' situations or "gotchas" in the scenario I've
described?

TIA,
Chris Hatfield
Falls Church, VA
US of A

hatfieldrc@gmail.com wrote:
> I have a probable need to exchange blobs between an Oracle database
> (which I don't control) and an ASE 12.0.0.4 database which I do
> control. These databases are on different servers that are not
> colocated. The blobs represent "attachments" to a particular "header"
> record in the database, and could be in the form of text, image,
> MSWord, spread sheet, etc., etc., etc. As I understand it, Oracle 9.i
> handles this through a db extension that stores information about what
> type of attachment is being stored in the blob and allowing the blob to
> be opened "gracefully". I have not used blobs in ASE, so I'm not aware
> of any potential difficulties from the ASE side.
>
> My inclination is to institute an Oracle to ASE replication flow and to
> let the respective engines take care of moving the stuff about the
> network(s). At this point in time, I believe that ASE will not need to
> ship the attachments back to Oracle, nor to perform modifications on
> the attachments once we have captured them on our server/in our DB.
>
> Can someone name the Sybase product(s) that we would need to accomplish
> this replication?
>
> Are there any 'heads-up' situations or "gotchas" in the scenario I've
> described?
>
> TIA,
> Chris Hatfield
> Falls Church, VA
> US of A

If what you propose doesn't work there is code at:
www.psoug.org
click on Morgan's Library
click on UTL_FILE
scroll down to "Extract BLOB Demo"

For reconstituting the original file as an operating system file.

HTH
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)