10 Replies Latest reply on Apr 21, 2017 2:09 PM by Alli Pierre Yotti

    Chart with no initial values

    Dernbauer

      Hi,

       

      I created a chart based on some items in a form.

       

      When i open that form:

      I got an error

       

      The source type is plsql

      the plsql is

       

       

      declare

          l_no_found varchar2(1000):=' select ''0'' LABEL,0 QUANTITY,''black'' color from dual';

          l_query varchar2(32767); 

        begin

          l_query :=   create_DQ_QRY(:P410_QUALITY_CONDITION,:P410_CONDITION_VALUE_ONE,:P410_ENTITY_ID,:P410_ATTRIBUTE_ID);

          wwv_flow.debug(l_query);

          return l_query;

       

        Exception

       

          When no_data_found then

          return  l_no_found;

          WHEN OTHERS THEN NULL;

        end;

       

      If I click the execute button (after putting in values for (:P410_QUALITY_CONDITION,:P410_CONDITION_VALUE_ONE,:P410_ENTITY_ID,:P410_ATTRIBUTE_ID)) it worked.

       

      It worked.

       

      How is it possible to do something like do not fire on initialization for the chart  ?

      thank you