Hi all,

The oracle table that I am writing to has a requirement for certain fields
to not be null but if I run a rule that detects an empty attribute and
passes a string space (" ") as the oracle guys desire the driver errors, if
I pass "NA" in a string its fine:-

<modify-attr attr-name="NAME_TITLE">
<remove-all-values/>
<add-value>
<value type="string"> </value>
</add-value>
</modify-attr>

Message: <description>Unable to modify object. Unable to update row(s) in
table/view 'AOPSHD1.PS_B89_CIS_EMPL_ST'.</description>
<object-dn>O=TEMPGROUP\OU=TEMP\OU=KDSTEST\CN=UAS00034</object-dn>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="1407"
jdbc:sql-state="72000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>ORA-01407: cannot update
("AOPSHD1"."PS_B89_CIS_EMPL_ST"."NAME_TITLE") to NULL
</jdbc:message>
<jdbc:stack-trace>java.sql.SQLException: ORA-01407: cannot update
("AOPSHD1"."PS_B89_CIS_EMPL_ST"."NAME_TITLE") to NULL

Here's the relevant part of the rule:-

<actions>
<do-set-dest-attr-value class-name="AOPSHD1.PS_B89_CIS_EMPL_ST"
name="NAME_TITLE">
<arg-value type="string">
<token-text xml:space="preserve"> </token-text>
</arg-value>
</do-set-dest-attr-value>
</actions>

Thank in advance!

Matt