|Subject:||creating temp file on the server|
|Posted by:||tal fts (tal.f…@gmail.com)|
|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