We have Oracle8i Enterprise Edition Release 220.127.116.11.0 - Production.
I need to read txt file from db package. File is located on my local machine. I use utl_file package and as I found I need to create a logical directory which points to physical one.
'Create or replace' command doesn't work from my db package, it gives mi ORA-22929. But it works from SQL.
CREATE OR REPLACE DIRECTORY v_dir AS 'C:\ab\cd';
GRANT READ ON DIRECTORY v_dir TO PUBLIC;
Even after creating logical directory in ALL_DIRECTORIES table, I'm getting INVALID_PATH error after command: