Hi All

I am running in probably some corner case or not seeing something obvious. Appreciate any help to resolve this.


We are running Oracle database standard edition on windows server 2012. We are trying to write a file output of a function to the directory on this windows box. However we are getting following errors. When I tested the same code on my local laptop (oracle 11g express) I do not get this error.

Function:

create or replace FUNCTION "F_FOOTER2" RETURN CLOB AS
PS_FOOTER2 CLOB;
BEGIN

SELECT '<groupList/>
<reservationList/>'
INTO PS_FOOTER2
FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER = 'NLS_CHARACTERSET'
;


DBMS_XSLPROCESSOR.CLOB2FILE(PS_FOOTER2, 'OUTPUT_INT_XML', 'footer2.xml');

return PS_FOOTER2;
END F_FOOTER2;






Error:

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 121
ORA-06512: at "PS_TMP.F_FOOTER2", line 13
ORA-06512: at line 5



Things we have tried/validated:

1. OUTPUT_INT_XML Directory has been defined and the actual directory exist in the windows drive. (this is not a shared drive but a local drive)

2. This directory in Database is defined under SYS, but the schema/user running above code has been granted read, write privileges to this directory

3. On windows server the schema user has been defined as a user with full access(read, write, execute) to the windows directory where we create the output file.

4. We bounced the database after defining all this parameters/directories etc

5. we are able to load data from this directories into the database, so we know the 'read' part is working