oracle10g - ORACLE APEX and UTL_FILE - creating a file on the server where database is installed -
I'm not sure what I'm trying to do. I'm calling a process from any app (or SQL Workshop) app. This process should be written to the server using UTl_FILE. However, this does not work. I have not received any errors, all relevant messages are displayed and updated. However, the output file is not created when I work from this SQL prompt on this server, it works! Since the APEX server resides in the database, I have thought that I can call a process to write on the server. I have completed all necessary things like making a directory and giving necessary personal provisions. I also tried to use the wrong directory name and I got the error which I expected so that the directory can be accepted. I am running Oracle 10G version 10.2.0.3.0 and Apax version 3.2.0.00.27. Oracle Radahat is running on Linux. All the appropriate items are in my schema Is it possible or do I need to find another way to do this? I have given APEX_PUBLIC_USER the READ and WRITE privileges on the directory? I really appreciate some help on this because it's really getting frustrating! I use UTL_FILE for a lot of things, so I am very familiar with how it works.
I have done 2 things
1) As my local C drive, I hope that I got the following message:
ORA- 29283: Invalid file operation ORA-06512: On "SYS.UTL_FILE", line 475 ORA-29283: Invalid file operation
2) I run the following code from the SQL Workshop:
declared v_get boolean; V_size number; V_block binary_integer; Start utl_file.fgetattr ('SQUID_TEST', 'Settlement_dates_20000106 CSV', v_get, v_size, v_block); If v_get then dbms_output.put_line ('this exists'); Else dbms_output.put_line ('Shame!'); end if; End;
And the output was as follows:
Should be ashamed! Details processed. 0.00 seconds
I ran a single code on the server from SQL Plus and the result was:
This is the PL / SQL process that has been successfully completed .
The file is as true, it is really confusing, I have not found any errors, and now I have given my Oracle directory the READ and write to apixtubleiuser and apxj 3030 .
Comments
Post a Comment