If you are using Oracle 8i, run db_mail_install_8i.sql file instead of db_mail_install_8.sql. This file can be found in the DB Mail installation directory which by default is c:\Program Files\DB Mail : When I try to execute the following: SELECT : send_mail('TWINGFIELD@NCTR.FDA.GOV', : 'Test message', : 'DB Mail has been successfully installed', : 'TWINGFIELD@NCTR.FDA.GOV') : FROM dual ; : I get this error: "ORA-06571: Function SEND_MAIL does not guarantee not : to update database" : I have tried puting the function in a package and using the following pragma : PRAGMA RESTRICT_REFERENCES(SEND_MAIL,WNDS); : but I get the following error : PLS-00452: Subprogram 'SEND_MAIL' violates : its associated pragma : Any ideas? : Thanks : Tim
|