creating temp file on the server

Hi

i need to create a temporary file on the server (an xml file) send it by email using smtp (which i know how) and than delete the temp file

i know there is the UTL_FILE_DIR, but i dont know what's inside of it.

i read i can use the creat or replace directory option but the problem is that only sys or admin can run it and i need to do it from my procedure as other user, also i dont know why i get pls-00103 on this line

so i guess i cant write the create.... in a procedure...?????!!!!!!!

any help/other option

10x Received on Wed Oct 19 2005 - 11:38:51 CDT