tag:blogger.com,1999:blog-18037024.post7726481112983274028..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: ORA-06502 with APEX_MAIL.SENDByte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18037024.post-26399398511944748882008-07-08T10:42:00.000+02:002008-07-08T10:42:00.000+02:00Hello,I've just replied on the forum, i believe th...Hello,<BR/>I've just replied on the forum, i believe the problem is in the function call where you pass just one parameter defined as CLOB, whereas you should define both p_body and p_body_html as CLOB.<BR/>See also this article on <A HREF="http://oraclequirks.blogspot.com/2007/05/pls-00307-too-many-declarations-of-xyz.html" REL="nofollow">PLS-00307</A>.<BR/><BR/>Bye,<BR/>FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-84247439830206439532008-07-08T07:20:00.000+02:002008-07-08T07:20:00.000+02:00Hello: I cannot get APEX_MAIL.SEND to work with HT...Hello: <BR/><BR/>I cannot get APEX_MAIL.SEND to work with HTML text via a scheduler .. <BR/><BR/>http://forums.oracle.com/forums/thread.jspa?messageID=2633777�Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-18703308062752634032007-08-10T23:30:00.000+02:002007-08-10T23:30:00.000+02:00If it were as you say, i wouldn't get an email eve...If it were as you say, i wouldn't get an email ever4 hours since 2 months, because that's the way i am calling this procedure in my pager application.<BR/><BR/>Moreover if you look at the package specification, you will see that all those parameters have a null as default value, so passing a null value wouldn't change much the situation.<BR/><BR/>Bye,<BR/>FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-57940396380699223962007-08-10T17:25:00.000+02:002007-08-10T17:25:00.000+02:00You have to send a value for all the variables in ...You have to send a value for all the variables in the apex_mail.send procedure. that is why you're getting the error. <BR/><BR/>try using nulls for the bcc_v and cc_v and non_html_body_v<BR/>vars.Anonymousnoreply@blogger.com