I see the following error:
read_demo exec ('test.txt');
Line 41 says:
Error at line 1 ORA-29292: file rename operation failed ORA-06512: at "SYS.UTL_FILE", line 340 ORA-06512: at "SYS.UTL_FILE", line 1186 ORA-06512: at "XAJTDB.READ_DEMO", line 41 ORA-06512: at line 1
The directories exist:
utl_file.frename ('ORALOAD', 'test.txt', 'CORRECTOS', 'correcto_test.txt', TRUE);
CREATE OR REPLACE DIRECTORY CORRECTOS AS 'C: \ temp \ test_utl_file \ CORRECTOS'; GRANT READ, WRITE ON DIRECTORY CORRECTOS TO XAJTDB WITH GRANT OPTION; CREATE OR REPLACE DIRECTORY AS ORALOAD 'C: \ temp \ test_utl_file \'; GRANT READ, WRITE ON DIRECTORY ORALOAD TO XAJTDBWITH GRANT OPTION;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!