"Michael Meyer" <michael_meyer@csgsystems.com> wrote in message
news:uToCp2u7HHA.5184@TK2MSFTNGP03.phx.gbl...
> The setup is Microsoft SQL Server 2005 as the publisher for transactional
> replication to an Oracle Subscriber.
> There are some not null columns that have empty strings in them and when
> it gets to the Oracle subscriber it is being translated in to null and
> causing
> an ORA-01400 (cannot insert null into...) error.
>
> Is there any thing in the setup of replication that can help avoid this
> situation?
>
> Thanks
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:ejNESzv7HHA.1204@TK2MSFTNGP03.phx.gbl...
> Can you convert the empty strings into a single space on the publisher?
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Michael Meyer" <michael_meyer@csgsystems.com> wrote in message
> news:uToCp2u7HHA.5184@TK2MSFTNGP03.phx.gbl...
>> The setup is Microsoft SQL Server 2005 as the publisher for transactional
>> replication to an Oracle Subscriber.
>> There are some not null columns that have empty strings in them and when
>> it gets to the Oracle subscriber it is being translated in to null and
>> causing
>> an ORA-01400 (cannot insert null into...) error.
>>
>> Is there any thing in the setup of replication that can help avoid this
>> situation?
>>
>> Thanks
>>
>
>

"Michael Meyer" <michael_meyer@csgsystems.com> wrote in message
news:uU2ej7v7HHA.5752@TK2MSFTNGP04.phx.gbl...
> Do you mean in the application code itself that is populating the column
> or would there be some means of doing this in SQL Server 2005 itself
> outside of using the compatibility setting?
>
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:ejNESzv7HHA.1204@TK2MSFTNGP03.phx.gbl...
>> Can you convert the empty strings into a single space on the publisher?
>>
>> --
>> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Michael Meyer" <michael_meyer@csgsystems.com> wrote in message
>> news:uToCp2u7HHA.5184@TK2MSFTNGP03.phx.gbl...
>>> The setup is Microsoft SQL Server 2005 as the publisher for
>>> transactional replication to an Oracle Subscriber.
>>> There are some not null columns that have empty strings in them and when
>>> it gets to the Oracle subscriber it is being translated in to null and
>>> causing
>>> an ORA-01400 (cannot insert null into...) error.
>>>
>>> Is there any thing in the setup of replication that can help avoid this
>>> situation?
>>>
>>> Thanks
>>>
>>
>>
>
>