0 Replies Latest reply on Jul 17, 2009 1:08 PM by braseth

    How to call "alter session set" in CF hitting Oracle

    braseth Level 1

      We have a problematic query in the Oracle 11g, using CFMX 7, and our DBAs have asked us to run this code:

       

      alter session set  _b_tree_bitmap_plans=true

       

      OUR QUERY

       

      alter session set  _b_tree_bitmap_plans=false

       

      Does anyone know how to do this? We've encapsulated the calls in separate CFQUERY tags but it does not seem to work.