when i am trying to use utl_file.fopen it gave me an error ORA-29280: utl_file.fopen invalid directory path error and this what i did: [code] CREATE DIRECTORY mydir AS 'C:\New'; [/code] [code] GRANT READ ON DIRECTORY mydir TO myuser; [/code] then using [code] v_FileHandle := UTL_File.FOpen('mydir', 'myfile', 'w', 32767); [/code] and this the final ...
Home/directory
Oraask Latest Questions
Question
Question
suppose we have created new directory on database server and give it required privileges like : [code]CREATE OR REPLACE DIRECTORY TEST_DIR AS '/usr/tmp'; GRANT READ, WRITE ON DIRECTORY TEST_DIR TO MYUSER;[/code] Now i want to know if oracle has capable to read and ...
Question
hello, Ii got an error when I want to use my directory created inside UTL_FILE.FOPEN invalid directory path within the procedure to open a certain file on my local machine.