Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
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.