This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Apr 16, 2013 3:47 AM by Hilary Go to original post RSS
  • 15. Re: Select x-axis into chart
    Hilary Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points