1 2 Previous Next 17 Replies Latest reply: Apr 16, 2013 5:47 AM by Hilary-Oracle Go to original post RSS
      • 15. Re: Select x-axis into chart
        Hilary-Oracle
        Hi Thorsten,

        The reason the following won't work for you when you set 'Query Source Type' to 'Function Returning SQL Query' is because it's not a PL/SQL function - you're not returning anything:
        declare v_sql varchar2(2000);
        begin
        v_sql := 'select  null link,variable1,variable2 from mv_auswertung';
        end;
        To resolve your issue, try the following:
        begin
        return 'select  null link,variable1,variable2 from mv_auswertung';
        end;
        Also, when you update your query to reference your page item e.g. P1_COL, ensure that you add that item to the 'Page Items to Submit' item on the Chart Series page.


        Regards,
        Hilary
        • 16. Re: Select x-axis into chart
          user134954
          Tried, but still getting an emtpy chart.

          PLS-00372: In a procedure, RETURN statement cannot contain an expression when trying in sql-developer.

          Edited by: Thorsten on 16.04.2013 03:09
          • 17. Re: Select x-axis into chart
            Hilary-Oracle
            Hi Thorsten,

            I've added an example to my sample application, here: https://apex.oracle.com/pls/apex/f?p=36648:108. Hopefully this helps.

            Regards,
            Hilary
            1 2 Previous Next