Calling UTL_FILE from APEX
Hi all,
I'm not sure if what I'm trying to do is possible. I'm calling a procedure from an APEX application (or from the SQL workshop). This procedure should write to the server using UTl_FILE. However, it doesn't work. I don't get any errors, all the appropriate messages are displayed and the updates are done. However, the output file is not created.
When I run the process from the SQL prompt on the server it works! Since APEX lives in the database on the server, I would have thought that I can call a process to write to the server. I'm writing to a directory on the database server.
I'm not sure if what I'm trying to do is possible. I'm calling a procedure from an APEX application (or from the SQL workshop). This procedure should write to the server using UTl_FILE. However, it doesn't work. I don't get any errors, all the appropriate messages are displayed and the updates are done. However, the output file is not created.
When I run the process from the SQL prompt on the server it works! Since APEX lives in the database on the server, I would have thought that I can call a process to write to the server. I'm writing to a directory on the database server.
0