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).

    
      
        oraext:query-database("SELECT COUNT (STORE_ID) AS TOTAL_PROMO FROM SE_INT_FWK.SE_CAT_STORE",true(),true(),"jdbc/fwk")
        $totalStores