utl_file_dir parameter

hi,

what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.

thanks,

Quote:

---

Originally Posted by iris

hi,

what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.

thanks,

---

[orapreprod@erpnode2 ~]$ sqlplus sysdba/sysdba as sysdba
Connected:
SQL> show parameter utl_file_dir;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string /tmp, /usr/tmp

It's pretty much the temp dir and i'm not sure (i personaly don't think) if it has anything to do with the smtp parameter.

Quote:

---

Originally Posted by iris

what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.

---

Ora10g?
utl_file_dir is deprecated, still there for backward compatibility - use Create Directory instead.

Quote:

---

Originally Posted by iris

hi,

what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.

thanks,

---

and no it has nothing to do with the sending emails

a 2 min search in the documentation would have proved this of course