Toad World® Forums

Utl_file not working for excel/window file

#1

CREATE OR REPLACE DIRECTORY
FILE_OP_DIR AS
'C:\';

GRANT EXECUTE, READ, WRITE ON DIRECTORY FILE_OP_DIR TO BANINST1 WITH GRANT OPTION;

GRANT EXECUTE, READ ON DIRECTORY FILE_OP_DIR TO BAN_DEFAULT_M;

GRANT READ ON DIRECTORY FILE_OP_DIR TO BAN_DEFAULT_PAGEBUILDER_M;

GRANT EXECUTE, READ ON DIRECTORY FILE_OP_DIR TO BAN_DEFAULT_Q;

GRANT READ ON DIRECTORY FILE_OP_DIR TO BAN_SS_USER;

GRANT EXECUTE, READ ON DIRECTORY FILE_OP_DIR TO PUBLIC;

GRANT EXECUTE, READ, WRITE ON DIRECTORY FILE_OP_DIR TO STCL_CODE;

In pl/sql giving error 'Invalid path'