Please post your message on the Oracle Tools message board at http://www.softtreetech.com/cgi_bin/mconfig.cgi By the way, if you get "table or view does not exist", it means you either have something missing in your database or have no permissions to access some object. Did you create public synonym or granted permissions to DB Mail objects to the user who runs DB Mail functions?
Have you tried to reinstall DB Mail? Please reply in the Oracle Tools message board. : Hi! I would be pleased if somebody can help me. I have created all the
: database objects needed for DB Mail: send_mail, attach_data and
: attach_file functions, the mail_attach table and the mail_attach_seq
: sequence. Also are granted the necesary permissions and created the public
: synonyms for all them. : I have permission to CREATE ANY DIRECTORY (with Read implicit) in Oracle.
: This database is on Windows NT 4, the Oracle Home is E:\orant, being E: a
: logical partition on the local server's HDD. The directory I've created is
: 'attachment', with the next syntax: CREATE OR REPLACE DIRECTORY ATTACHMENT
: AS 'E:\ORANT\NET80\ADMIN'; : Then, I try to send a message with an attachment: the file TNSNAMES.ORA,
: located in the mentioned directory. For that purpose, I used the
: attach_file function as seen on the DB Mail examples (replacing necessary
: data): DECLARE
: attach_id INTEGER;
: ret_code INTEGER;
: BEGIN
: attach_id := Attach_File(NULL, 1, 'tnsnames.ora', 'attachments');
: ret_code := send_mail('lrozas@lemans.cl', 'Test message with attachments...
: LEO', 'This message has one attachment... LEO', NULL, NULL, NULL,
: attach_id);
: END;
: / : I receive the mail, but it comes with no attachment. The DB Mail console
: shows an error: table or view does not exist. : Does somebody know what is happening? Thank you very much for your help and
: sorry about my english, I'm writing from Chile (we speak Spanish)...
|
