Re: [sqr-users] Sending E-mail from SQR

["George Jansen" <GJANSEN@aflcio.org>]

Since you have Oracle, why not use the utl_smtp package? Have a look at the 
Provided PL/SQL Packages documentation.

>>> calebrun@yahoo.com 04/25/04 04:57PM >>>
 --- Harry R Harris <HHARRIS@alegent.org> a écrit : > I am trying to send an 
email from within an
SQR using the following:
> 
> let $mail_cmd = 'echo' || $body || '|' || ' mailx -s ' || $subject ||
> $address
> 
> call system using $mail_cmd #status nowait
> 
> Seems to work fine until $body contains more than about 500
> characters.???
> 
> We are: SQR for PeopleSoft/8.19/IBM RS6000/AIX 5.1/Oracle 9.2.0.4
> 
> 

Hello

You can try to produce an ASCII text file from SQR (open-file, etc...) then 
send it with something
like (suppose you named you text file 'email-text.txt') :

let $mail_cmd = 'cat email-text.txt |' || ' mailx -s ' || $subject || $address
call system using $mail_cmd #status nowait

Here you should not reach the 500 char limit...

Hope this helps,

Charly

=====
Charly Lebrun
calebrun@yahoo.com 

_________________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users