Handle Unmapped Required Values
This page last changed on Nov 28, 2008.
Oracle Data Service Integrator Documentation > Data Services Developer's Guide How To Handle Unmapped Required ValuesThis topic describes how to enable an update map when the data sources on the left have required elements that are not mapped from the return type on the right. OverviewWhen required mappings are missing, the Create-Update-Delete procedures for the update block are disabled. That means you cannot create, update, or delete the underlying data sources. In Workshop for WebLogic, the update map looks like this. Required Mappings Are Missing
If an element is required but does not have a value, it is marked with a Warning icon . In either case, the Create, Update, or Delete procedures do not work, so you need to resolve the error. You can do either of these:
Draw the MappingTo draw the mapping in the Query Map tab:
Make sure the elements have the same data types or similar data types that are cast implicitly. Cast a ConstantIf you enter a constant to override the missing mapping, it is only used with Create procedures, to insert data into the data source. Update procedures ignore the override values you enter and leave the data source unchanged. (Of course, Delete procedures delete a record from the data source, so override values are not relevant to them.) When you enter an override value, make sure the value you enter has the data type the element in the physical data source requires. You can enter a constant like "44" or "2007-01-01" and cast it to an XML Schema data type such as xs:integer or xs:date, using either of these:
The parentheses cast operator uses any XML Schema data type outside the parentheses and a string that is appropriate for the data type you are casting to within the parentheses. For example, you can perform these casts: xs:date("2007-01-01") xs:dateTime("2007-01-01T16:44:44") xs:integer("44") But you cannot perform these: xs:date("2007-01-01T16:44:44") xs:dateTime("date") xs:integer("text") To cast a constant in the expression editor:
See AlsoConceptsHow TosOther Resources
|
Document generated by Confluence on Jan 13, 2009 15:57 |