Example query-database in BPEL 11g

This is an example of how to query directly from the database from BPEL, it can be done using an Assign or Tranform (XSLT).

view source

print?

1	<assign name="setTotalStores">

2

<copy>

3	<from>oraext:query-database("SELECT COUNT (STORE_ID) AS TOTAL_PROMO FROM SE_INT_FWK.SE_CAT_STORE",true(),true(),"jdbc/fwk")</from>

4	<to>$totalStores</to>

5

</copy>

6

</assign>