Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|pl/sql parameter is null sometimes||2||40|
|Cannot connect to Oracle database, python not recognizing cx_Oracle||2||71|
|How to combine two oracle database together||9||77|
|Oracle function return value when null||2||34|
Join the community of 500,000 technology professionals and ask your questions.