SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Select Error

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Select Error
Author Message
Tim Wingfield



Joined: 09 Jan 2001
Posts: 2

Post Select Error Reply with quote

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

Tue Jan 09, 2001 5:41 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Select Error Reply with quote

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

Tue Jan 09, 2001 5:58 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.