Home » SQL & PL/SQL » SQL & PL/SQL » UTL_SMTP Package Body
icon9.gif  UTL_SMTP Package Body [message #242570] Mon, 04 June 2007 02:43 Go to next message
Messages: 10
Registered: June 2005
Junior Member
I am using oracle 8.1.7
I want to send email of more that 10,000 charaters but the UTL_SMTP package allows only 4000 characters because it uses varchar2 datatype for message body of the email.

Is it possible to find the package body of UTL_SMTP package?

I found its specs from \Oracle\ora81\rdbms\admin\utlsmtp.sql
but body is not there.

Actually I have to chage the data type from varchar2 to long
in write_text procedure of the package.
I have changed this from specs but i couldn't change from body. and thats why i am facing problem while using utl_smtp package for email.

I ll greatfull if somebody helps me in this regard

Re: UTL_SMTP Package Body [message #242611 is a reply to message #242570] Mon, 04 June 2007 06:05 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Go to AskTom and put "send mail" in search field.
Tom covers this subject for so many cases that you surely find something that can suit you.

Previous Topic: Help need for DBMS_JOB
Next Topic: how to indentify the coloum
Goto Forum:

Current Time: Thu Jul 27 21:44:36 CDT 2017

Total time taken to generate the page: 0.11641 seconds