4 Replies Latest reply on Jul 11, 2019 4:22 AM by Sek1491

    Unable to display file in apex screen

    Sek1491

      I am using utl_file to display a file from os file system to oracle apex scree.

      To achieve this i have written below code in a plsql dynamic region in my oracle apex page.

      This is running properly in sql command prompt but not displaying in my page.

      Here is my code.

       

      Declare

        f UTL_FILE.FILE_TYPE;

        s VARCHAR2(4000);

      begin

        f:= UTL_FILE.FOPEN('IMAGES','2.PNG','R');

        UTL_FILE.GET_LINE(f,s);

        UTL_FILE.FCLOSE(f);

        dbms_output.put_line(s);

      end;

       

      Can anyone help me in this ?