Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOBs from Oracle to MS Sql server

Re: BLOBs from Oracle to MS Sql server

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 13 Sep 2002 09:19:52 +0100
Message-ID: <3d819fa7$0$8505$cc9e4d1f@news.dial.pipex.com>

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:als488$on0$1_at_ctb-nnrp2.saix.net...
> PL/SQL can not pull the BLOB from SQL-Server. You will need either an
> external stored proc for it (similar to extended procs on SQL-Server) that
> allows you to get access to SQL-Server , or Oracle's Transparant Gateway
> for SQL-Server.

Isn''t the load going the other way? As you say though this solution would work just fine

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Sep 13 2002 - 03:19:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US