Wednesday, February 5, 2014

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
      
     

No comments:

Post a Comment