UTL FILE WRITE INTO A FILE

[@sydneymolobela4953]

Well done, bro! Thank you very much. You helped me with my exam preparation for my bachelors. God bless you. I was stuck.

[@diegodelapuente1665]

Hey Sridhar, the only thing that was unclear was utl_file.sql which you used to create the USER_DIR variable to hold the path which the file handle will access. I know you specified that file but no connection between SQL Developer and the utl_file.sql was made. Perhaps you can clarify that?

[@raghavendramaiyabc]

Good EduVideo. Do you know how to extract .docx file from BLOB/Long Raw column of Oracle to a Windows folder? If so please share the video or link containing end to end steps.

[@youssefmohamed4170]

My files and directories are placed in a server not on my machine, and this exception (UTL_FILE.INVALID_OPERATION) appears. What do you think I should do? ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 633 ORA-29283: invalid file operation ORA-06512: at line 6

[@bhaktikhot8868]

Hi Shirdhar , I am getting a invalid file exception can you suggest something

[@jayakrishnachanumuru]

Thank you sir

[@siddhartharao8490]

Sir, can you please explain the difference between Utl_file.put and UTL_file.Put_line?

[@diegodelapuente1665]

Do you have the Oracle DB installed on your machine or is this running on a server?

[@sridharraghavan4120]

Diego De La Puente oracle dB is installed in my machine

[@mohitnarang2194]

sir, i am not able to see the created directory in os though it is getting created in sql developer help.

[@pankajkharade6936]

use select * from all_directories;

[@dasubabuch1596]

Hi Sridhar, When am granting the executing permission, Getting below error. Could you please check it. GRANT EXECUTE ON utl_file TO rocky Error report - SQL Error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist"

[@vijayadiwakar3954]

Hair sridhar am getting ora _29283 error can u tell me

[@youssefmohamed4170]

I know it's too late to ask this but, Did you solve this and how ?

[@pratswagh2559]

Error report - ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation ORA-06512: at line 4 29283. 00000 - "invalid file operation%s" *Cause: An attempt was made to read from a file or directory that does not exist, or file or directory access was denied by the operating system. *Action: Verify file and directory access privileges on the file system, and if reading, verify that the file exists. ---------------------------------------------------------------------------- I am performing 'W' access mode for which my oracle is installed on linux server and i have granted directory rights to user using utl_file and have created a directory on my local windows desktop over which oracle sql developer is installed. Will this work ? Oracle is installed on different server and probably I must mention the directory of that only

[@EstebanGobello-Vendor]

I love you :D

[@Mohamed-uf5jh]

thanks you very clear and goog

[@rajeshyarlagadda2916]

nice bro

[@vijayadiwakar3954]

Now I got it I did wrong .

[@bhaktikhot8868]

Hi Vijaya I have the same ,can you please tell me how to solve it

[@youssefmohamed4170]

@@bhaktikhot8868 So did you solve this ?😅