Hi Suresh,

I established a linked server to Oracle9i database using Microsoft OLE DB
Provider for Oracle. Then I created the following table in SQL Server 2000.
CREATE TABLE testora1 (id int IDENTITY, name1 varchar(10))
INSERT testora1 VALUES(char(0))

Then I use a DTS package to transform SQL Server 2000 table to Oracle
table. When I use linked server to "SELECT * FROM Oracle1..SCOTT.testora1",
it returns empty value, not NULL.

Could you check if can use Microsoft OLE DB Provider for Oracle? In
addition, linked server issues are usually complex to troubleshoot in
newsgroups. I would suggest that you open an incident with Microsoft
Product Support Services via
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Suresh" <babu@synygy.com>
| Sender: "Suresh" <babu@synygy.com>
| Subject: char(0) is getting transformed to NULL in Oracle
| Date: Tue, 30 Sep 2003 12:16:26 -0700
| Lines: 11
| Message-ID: <043c01c38787$57f82200$a401280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOHh1f4R0QWYPyGQCCVSA2QIeDAVQ==
| Newsgroups: microsoft.public.sqlserver.dts
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:39268
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Hi,
| I have a DTS package that exports SQL Server 2000 data
| into Oracle 9i database. The char(0) values from varchar
| columns are getting transformed as NULLs in the Oracle
| database. I have connected to the destination server using
| Oracle OLEDB provider.
|
| If someone have a resolution for this issue, it will be
| highly appreciated.
| Thanks,
| Suresh
|

Hi Suresh,

Thanks for your understanding. You may let me know the incident number so
that I can monitor and post for community benefit.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Suresh" <babu@synygy.com>
| Sender: "Suresh" <babu@synygy.com>
| References: <043c01c38787$57f82200$a401280a@phx.gbl>
<SIkAPZBiDHA.2188@cpmsftngxa06.phx.gbl>
| Subject: RE: char(0) is getting transformed to NULL in Oracle
| Date: Wed, 1 Oct 2003 09:48:15 -0700
| Lines: 82
| Message-ID: <06da01c3883b$cef1b1a0$a101280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcOIO87xLbVNPFYpRpm0iH4qQu5RHw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.dts
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.dts:39322
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Bill,
| Thanks for the reply.
| As you perhaps be aware that there is no "empty value"
| concept for varchars in Oracle. I am using Char(0) as a
| work-around for this issue. As you have suggested, I will
| open an incident with Microsoft product support to get a
| resolution for this issue.
| -Suresh
| >-----Original Message-----
| >Hi Suresh,
| >
| >I established a linked server to Oracle9i database using
| Microsoft OLE DB
| >Provider for Oracle. Then I created the following table
| in SQL Server 2000.
| >CREATE TABLE testora1 (id int IDENTITY, name1 varchar(10))
| >INSERT testora1 VALUES(char(0))
| >
| >Then I use a DTS package to transform SQL Server 2000
| table to Oracle
| >table. When I use linked server to "SELECT * FROM
| Oracle1..SCOTT.testora1",
| >it returns empty value, not NULL.
| >
| >Could you check if can use Microsoft OLE DB Provider for
| Oracle? In
| >addition, linked server issues are usually complex to
| troubleshoot in
| >newsgroups. I would suggest that you open an incident
| with Microsoft
| >Product Support Services via
| >http://support.microsoft.com/default.aspx?scid=fh;EN-
| US;CNTACTMS, so that
| >we can have dedicated engineer to assist you.
| >
| >
| >Bill Cheng
| >Microsoft Online Partner Support
| >
| >Get Secure! - www.microsoft.com/security
| >This posting is provided "as is" with no warranties and
| confers no rights.
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Suresh" <babu@synygy.com>
| >| Sender: "Suresh" <babu@synygy.com>
| >| Subject: char(0) is getting transformed to NULL in
| Oracle
| >| Date: Tue, 30 Sep 2003 12:16:26 -0700
| >| Lines: 11
| >| Message-ID: <043c01c38787$57f82200$a401280a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcOHh1f4R0QWYPyGQCCVSA2QIeDAVQ==
| >| Newsgroups: microsoft.public.sqlserver.dts
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.sqlserver.dts:39268
| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| X-Tomcat-NG: microsoft.public.sqlserver.dts
| >|
| >| Hi,
| >| I have a DTS package that exports SQL Server 2000 data
| >| into Oracle 9i database. The char(0) values from
| varchar
| >| columns are getting transformed as NULLs in the Oracle
| >| database. I have connected to the destination server
| using
| >| Oracle OLEDB provider.
| >|
| >| If someone have a resolution for this issue, it will be
| >| highly appreciated.
| >| Thanks,
| >| Suresh
| >|
| >
| >.
| >
|