6 Replies Latest reply: Mar 28, 2013 9:28 AM by 958577 RSS

    select from dba_directories in pl/sql procedure

    655260
      hello,


      I tried to do this in a procedure but got an error:

      -----

      select count(*) into ocount from dba_directories where directory_name = 'DIR0001';

      -----


      error: table or view does not exist.


      Would someone suggest where this table can be found?


      Thank you.