11 Replies Latest reply on Jun 12, 2019 8:34 PM by fac586

    how to refresh text_area item during PL/SQL process

    Fabrizio Delli Priscoli

      Hi all, I'm on APEX 19.1.

      I have on a page a textarea item in which I want to show all the points of my process.

      I have a button that recall a page process, a PL/SQL code process, in which I make many recalls to a database package.

      What I want is that between a package call I assign a value to my textarea item and it is refreshed.

      Is it possible ? Or in case is not possible is there a way to achieve this?

      Thanks all for collaboration,

      Fabrizio

       

      Here is example of my PL/SQL page process:

       

       

      :120_MY_TEXTAREA := 'FIRST CALL TO PACKAGE'||chr(10);

      MY_PACKAGE.MY_PROCEDURE_1(:p120_year,:p120_month);

      if SQLCODE = 0 then

      :120_MY_TEXTAREA := :120_MY_TEXTAREA||'SECOND CALL TO PACKAGE'||chr(10);

      MY_PACKAGE.MY_PROCEDURE_2(:p120_year,:p120_month);

      else

      apex_error.add_error(p_message  =>'ERROR OCCURS: '||SQLERRM,p_display_location =>apex_error.c_on_error_page);

      end if;

       

      and so on....