Ability to Adhoc SQL using REF CURSOR based BIP Report not supported anymore - Page 4 — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability to Adhoc SQL using REF CURSOR based BIP Report not supported anymore

Submitted
783
Views
37
Comments
124»

Comments

  • Rich Lyman
    Rich Lyman Rank 1 - Community Starter

    Losing the ability to execute adhoc SQL queries is a gigantic step backwards.  Please provide an alternative rather than just disabling dynamic SQL.

  • User_SCN33
    User_SCN33 Rank 1 - Community Starter

    Dynamic sql ref cursor was the only way to have some personal query validations . Every time we cannot create data model reports etc to run some small validation query . Its a great problem unless we get some alternative like sql developer . 

  • Velmurugan Arappagounder
    Velmurugan Arappagounder Rank 1 - Community Starter

    Loss of time, have to go and create multiple data models to check underlying data instead of create SQL's on the fly

  • Rohera Kumar
    Rohera Kumar Rank 1 - Community Starter

    This is a Very useful way of running Dynamic SQL Queries mainly for users working with Oracle Cloud and 3rd party tools.

  • Sammy Bagchi
    Sammy Bagchi Rank 1 - Community Starter

    this is a big loss for the development team ... Oracle Cloud ERP itself lacks any practical way to run any query to look at the data. Dynamic SQL was the only way around and now it is closed as well.

     

    Oracle needs to come up with a tool fast.

  • M Abdala
    M Abdala Rank 1 - Community Starter

    very important request

  • User_M8ZEL
    User_M8ZEL Rank 1 - Community Starter

    Another vote. We need this