Hello-
I have created a oracle directory WCPOLS_DIR and which looks in dba_directories like this:-

OWNER	DIRECTORY_NAME	DIRECTORY_PATH
SYS	WCPOLS_DIR	/mnt/WCPOLS/PROCESSWCPOLS

Now I need to have a subfolder under this path where I am placing one input file to read in pl/sql code. So I created a directory 'test' under this path but when I run my code its giving an error invalid directory path. This is how I gave path to this test folder in plsql code.

declare
  w_dir                   VARCHAR2(100);
  w_input_file            VARCHAR2(50);
  input_file      utl_file.file_type;
  
  
BEGIN  
    
    w_dir            := 'WCPOLS_DIR\test'; -- This is how I am accessing test folder under the oracle directory
    w_input_file     := 'wcpols_04262016_05032016_CA.TXT';        
    input_file    := utl_file.fopen(w_dir, w_input_file, 'r',32000);
   
    
    IF utl_file.is_open(input_file) THEN
     LOOP

I was assuming when we have created a directory in oracle, we could access the sub directory under this path. Could you please advise where I am making miskate?

Thanks!

Thanks Barbara for your quick reply. So if the requirement is to have 11 folders

Subsequently asking "why" simply bloats the thread and adds no tangible value,