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

    select from dba_directories in pl/sql procedure


      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.