SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB_MAIL FOR ORACLE

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB_MAIL FOR ORACLE
Author Message
Michael Falkson



Joined: 15 Jan 2005
Posts: 1

Post DB_MAIL FOR ORACLE Reply with quote

declare x number;
begin
x := db_mail.send_mail ('falkson@etisales.com', 'New great product in our store',

'We are happy to offer the product that you have asked for. For details please see the attached picture.',

'falkson@etisales.com', 1, 'text/html' ) ;
---dbms_output.put_line(x);
---EXCEPTION WHEN OTHERS THEN NULL;
end;

GETTING

ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Sat Jan 15, 2005 12:15 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: DB_MAIL FOR ORACLE Reply with quote

You last 2 parameters in the wrong order, email type goes first then goes priority.

: declare x number;
: begin
: x := db_mail.send_mail ('falkson@etisales.com', 'New great product in our
: store',

: 'We are happy to offer the product that you have asked for. For details
: please see the attached picture.',

: 'falkson@etisales.com', 1, 'text/html' ) ;
: ---dbms_output.put_line(x);
: ---EXCEPTION WHEN OTHERS THEN NULL;
: end;

: GETTING

: ORA-06502: PL/SQL: numeric or value error: character to number conversion
: error

Sat Jan 15, 2005 5:25 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.