creating temp file on the server

Giganews Newsgroups
Subject: creating temp file on the server
Posted by:  tal fts (tal.f…
Date: 19 Oct 2005


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