Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

max characters UTL_SMTP.write_data() can handle

622443Mar 4 2008 — edited Sep 9 2010
Hi,
I have a procedure that sends mail using utl_smtp. Am getting the following error (exception) with utl_smtp.write_data() when the data size is huge:

ORA-06502: PL/SQL: numeric or value error

Can anybody let me know whats the max characters write_data() can send and what can be the max size of mail body.

How can i resolve the above error.

Any help is greatly appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2010
Added on Mar 4 2008
10 comments
14,205 views