Index: oracle.xml
===================================================================
--- oracle.xml	(revision 3485)
+++ oracle.xml	(working copy)
@@ -80,12 +80,12 @@
                 </property>
                 <property name="clobColumnTemplate">
                     <value>
-                        <![CDATA[ decode(dbms_lob.getlength($(tableAlias)."$(columnName)"), null, '', '"'||replace(replace($(tableAlias)."$(columnName)",'\','\\'),'"','\"')||'"') ||','||]]>                        
+                        <![CDATA[ case when $(tableAlias)."$(columnName)" is null then null else '"' || replace(replace($(tableAlias)."$(columnName)",'\','\\'),'"','\"') || '"' end ||','||]]>
                     </value>
                 </property>
                 <property name="blobColumnTemplate">
                     <value>
-                        <![CDATA[ decode(dbms_lob.getlength($(tableAlias)."$(columnName)"), null, '', '"'||$[sym.sync.table.prefix]_blob2clob($(tableAlias)."$(columnName)")||'"') ||','||]]>
+                        <![CDATA[ case when $(tableAlias)."$(columnName)" is null then null else '"' || fn_sym_blob2clob($(tableAlias)."$(columnName)") || '"' end ||','||]]>
                     </value>
                 </property>
                 <property name="numberColumnTemplate">
