Tuesday, July 17, 2012

SOA 11g DVM with Qualifier Example

DVM with Qualifier is little different.
Code.dvm

 ?xml version="1.0" encoding="UTF-8" ?
dvm name="Foods" xmlns=http://xmlns.oracle.com/dvm
description /description
columns
column name="KEY" qualifier="true"/
column name="NAME"/
column name="VALUE"/
/columns
rows
row
cellASIA/cell
cellINDIA/cell
cell91/cell
/row
row
cellASIA/cell
cellSRILANKA/cell
cell044/cell
/row
/rows
/dvm

 Function to use in Transformation or in Assign activity is as below
xsl:value-of select='dvm:lookupValue("Foods.dvm","NAME",/client:process/client:input,"VALUE","DEFAULTVALUE","KEY","ASIA")'/

 You can find more information in the below URL.
Example:
http://docs.oracle.com/cd/E21764_01/integration.1111/e10224/med_dvm.htm#autoId3
Posted by at

2 comments:

  1. Harshita3:50 PM

    Hi Vijay,

    My requirement is to check if country specified by the user is present in dvm.If the value matches than perform some operation. Now whenever I do dvm lookup, default value is retrieved. Please help me here asap.

    Below is my dvm file and the query used





    ?xml version='1.0' encoding='UTF-8'?>

    DVM description






    Sweden
    true


    Denmark
    true




    Thanks in advance

    Regards,
    Harshita M

    ReplyDelete
  2. Harshita3:51 PM

    Hi Vijay,

    My requirement is to check if country specified by the user is present in dvm.If the value matches than perform some operation. Now whenever I do dvm lookup, default value is retrieved. Please help me here asap.

    Below is my dvm file and the query used





    ?xml version='1.0' encoding='UTF-8'?>

    DVM description






    Sweden
    true


    Denmark
    true




    Thanks in advance

    Regards,
    Harshita M

    ReplyDelete

Subscribe to: Post Comments (Atom)