| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Send a mail with PL/SQL
as far as I know email is not directly supported by PL/SQL.
you could write your mail to a file and have an OS-script process this
file.
If you have to execute a lot of OS commands, you can use a PRO*C program that communicates with your package via a pipe. I almost literally reused the example from the Oracle documentation set and it works fine.
attached: PRO*C source and a PL/SQL wrapper package from the doc. set: (8 – 14 Oracle7 Server Application Developer’s Guide)
Sbaiz <pierluigi.sbaiz_at_elsag.it> wrote in article
<01bdb616$0aab82f0$b8cd5997_at_sbaiz>...
> Hi to all
>
> Someone know if It's possible send a mail to an internet address from
> PL/SQL?
> Thanks in advance!
>
> Sbaiz P.
>
>
begin 600 un.sql
M#0I#4D5!5$4_at_3U(@4D503$%#10T*4$%#2T%'12!P8VM?1E=?=6YI>&-O;6UA
M;F0-"F%S#0H-"F9U;F-T:6]N(&5X96-U=&5?<W%L#0H@(" @* T*(" @(&-O
M;6UA;F0@=F%R8VAA<C(L#0H@(" @=&EM96]U="!N=6UB97(@9&5F875L=" Q
M, T*(" @("D-"B @("!R971U<FX@;G5M8F5R#0H@(" @.PT*#0IF=6YC=&EO
M;B!E>&5C=71E7W-Y<W1E;0T*(" @("@-"B @("!C;VUM86YD('9A<F-H87(R
M+ T*(" @('1I;65O=70@;G5M8F5R(&1E9F%U;'0@,3 -"B @(" I#0H@(" @
M<F5T=7)N(&YU;6)E<@T*(" @(#L-"@T*<')O8V5D=7)E('-T;W -"B @(" H
M#0H@(" @=&EM96]U="!N=6UB97(@9&5F875L=" Q, T*(" @("D-"B @(" [
M#0I%3D0@<&-K7T977W5N:7AC;VUM86YD.PT*+PT*#0H-"D-214%412!/4B!2
M15!,04-%#0I004-+04=%($)/1%D@(" @('!C:U]&5U]U;FEX8V]M;6%N9 T*
M87,-"@T*+RHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BHJ*BHJ*B\-"F9U;F-T:6]N(&5X96-U=&5?<WES=&5M#0H@M(" @* T*(" @(&-O;6UA;F0@=F%R8VAA<C(L#0H@(" @=&EM96]U="!N=6UB M97(@9&5F875L=" Q, T*(" @("D-"B @("!R971U<FX@;G5M8F5R#0II<PT* M#0IS=&%T=7,@;G5M8F5R.PT*<F5S=6QT('9A<F-H87(R*#(P*3L-"F-O;6UA M;F1?8V]D92!N=6UB97([#0IP:7!E7VYA;64@=F%R8VAA<C(H,S I.PT*#0I" M96=I;@T*(" @('!I<&5?;F%M92 Z/2!D8FUS7W!I<&4N=6YI<75E7W-E<W-I
M;VY?;F%M93L-"B @("!D8FUS7W!I<&4N<&%C:U]M97-S86=E*"=365-414TG
M*3L-"B @("!D8FUS7W!I<&4N<&%C:U]M97-S86=E*'!I<&5?;F%M92D[#0H@
M(" @9&)M<U]P:7!E+G!A8VM?;65S<V%G92AC;VUM86YD*3L-"B @("!S=&%T
M=7,@.CT_at_9&)M<U]P:7!E+G-E;F1?;65S<V%G92_at_G9&%E;6]N)RP@=&EM96]U
M="D[#0H@(" @:68@<W1A='5S(#P^(# @=&AE;@T*(" @(" @("!R86ES95]A
M<'!L:6-A=&EO;E]E<G)O<B_at_M,C P,3 L("=%>&5C=71E7W-Y<W1E;3H_at_17)R
M;W(@=VAI;&4@<V5N9&EN9RX_at_4W1A='5S(#T@)R!\?'-T871U<RD[#0H@(" @
M96YD(&EF.PT*(" @('-T871U<R Z/2!D8FUS7W!I<&4N<F5C96EV95]M97-S
M86=E*'!I<&5?;F%M92P@=&EM96]U="D[#0H@(" @:68@<W1A='5S(#P^(# @
M=&AE;@T*(" @(" @("!R86ES95]A<'!L:6-A=&EO;E]E<G)O<B_at_M,C P,3$L
M("=%>&5C=71E7W-Y<W1E;3H_at_17)R;W(@=VAI;&4@<F5C96EV:6YG+E-T871U
M<R ]("<@?'P@<W1A='5S*3L-"B @("!E;F0@:68[#0H@(" @9&)M<U]P:7!E
M+G5N<&%C:U]M97-S86=E*')E<W5L="D[#0H@(" @:68@<F5S=6QT(#P^("=D
M;VYE)R!T:&5N#0H@(" @(" @(')A:7-E7V%P<&QI8V%T:6]N7V5R<F]R*"TR
M,# Q,BP@)T5X96-U=&5?<WES=&5M.B!$;VYE(&YO="!R96-E:79E9"XG*3L-
M"B @("!E;F0@:68[#0H@(" @9&)M<U]P:7!E+G5N<&%C:U]M97-S86=E*&-O
M;6UA;F1?8V]D92D[#0HM+61B;7-?;W5T<'5T+G!U=%]L:6YE*"=3>7-T96T@
M8V]M;6%N9"!E>&5C=71E9"X@<F5S=6QT(#T@)R!\?&-O;6UA;F1?8V]D92D[
M#0IR971U<FX_at_8V]M;6%N9%]C;V1E.PT*96YD(&5X96-U=&5?<WES=&5M.PT*
M#0HO*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ
M*BHJ*BHJ*BHJ*BHJ+PT*9G5N8W1I;VX_at_97AE8W5T95]S<6P-"B @(" H#0H@
M(" @8V]M;6%N9"!V87)C:&%R,BP-"B @("!T:6UE;W5T(&YU;6)E<B!D969A
M=6QT(#$P#0H@(" @*0T*(" @(')E='5R;B!N=6UB97(-"DE3#0H-"G-T871U
M<R!N=6UB97([#0IR97-U;'0@=F%R8VAA<C(H,C I.PT*8V]M;6%N9%]C;V1E
M(&YU;6)E<CL-"G!I<&5?;F%M92!V87)C:&%R,B_at_S,"D[#0H-"F)E9VEN#0H@
M(" @<&EP95]N86UE(#H](&1B;7-?<&EP92YU;FEQ=65?<V5S<VEO;E]N86UE
M.PT*(" @(&1B;7-?<&EP92YP86-K7VUE<W-A9V4H)U-13"<I.PT*(" @(&1B
M;7-?<&EP92YP86-K7VUE<W-A9V4H<&EP95]N86UE*3L-"B @("!D8FUS7W!I
M<&4N<&%C:U]M97-S86=E*&-O;6UA;F0I.PT*(" @('-T871U<R Z/2!D8FUS
M7W!I<&4N<V5N9%]M97-S86=E*"=D865M;VXG+"!T:6UE;W5T*3L-"B @("!I
M9B!S=&%T=7,@/#X@,"!T:&5N#0H@(" @(" @(')A:7-E7V%P<&QI8V%T:6]N
M7V5R<F]R*"TR,# R,"P@)T5X96-U=&5?<W%L.B!%<G)O<B!W:&EL92!S96YD
M:6YG+B!3=&%T=7,@/2 G('Q\('-T871U<RD[#0H@(" @96YD(&EF.PT*(" @
M('-T871U<R Z/2!D8FUS7W!I<&4N<F5C96EV95]M97-S86=E*'!I<&5?;F%M
M92P@=&EM96]U="D[#0H@(" @:68@<W1A='5S(#P^(# @=&AE;@T*(" @(" @
M("!R86ES95]A<'!L:6-A=&EO;E]E<G)O<B_at_M,C P,C$L("=E>&5C=71E7W-Q
M;#H_at_17)R;W(@=VAI;&4@<F5C96EV:6YG+B!3=&%T=7,@/2 G('Q\('-T871U
M<RD[#0H@(" @96YD(&EF.PT*(" @(&1B;7-?<&EP92YU;G!A8VM?;65S<V%G
M92AR97-U;'0I.PT*(" @(&EF(')E<W5L=" \/B G9&]N92<@=&AE;@T*(" @
M(" @("!R86ES95]A<'!L:6-A=&EO;E]E<G)O<B_at_M,C P,C(L("=E>&5C=71E
M7W-Q;#H_at_9&]N92!N;W0@<F5C96EV960N)RD[#0H@(" @96YD(&EF.PT*(" @
M(&1B;7-?<&EP92Y53G!A8VM?;65S<V%G92AC;VUM86YD7V-O9&4I.PT*+2UD
M8FUS7V]U='!U="YP=71?;&EN92_at_G4U%,(&-O;6UA;F0_at_97AE8W5T960N('-Q
M;&-O9&4@/2 G('Q\(&-O;6UA;F1?8V]D92D[#0H@(" @<F5T=7)N(&-O;6UA
M;F1?8V]D93L-"F5N9"!E>&5C=71E7W-Q;#L-"@T*+RHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ M*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*BHJ*B\-"G!RM;V-E9'5R92!S=&]P#0H@(" @* T*(" @('1I;65O=70@;G5M8F5R(&1E9F%U
M;'0@,3 -"B @(" I#0II<PT*#0IS=&%T=7,@;G5M8F5R.PT*#0IB96=I;@T*
M(" @(&1B;7-?<&EP92YP86-K7VUE<W-A9V4H)U-43U G*3L-"B @("!S=&%T
M=7,@.CT_at_9&)M<U]P:7!E+G-E;F1?;65S<V%G92_at_G9&%E;6]N)RP@=&EM96]U
M="D[#0H@(" @:68@<W1A='5S(#P^(# @=&AE;@T*(" @(" @("!R86ES95]A
M<'!L:6-A=&EO;E]E<G)O<B_at_M,C P,S L("=S=&]P.B!E<G)O<B!W:&EL92!S
M96YD:6YG+B!S=&%T=7,@/2 G('Q\('-T871U<RD[#0H@(" @96YD(&EF.PT*
I96YD('-T;W [#0IE;F0@<&-K7T977W5N:7AC;VUM86YD.PT*+PT*#0IF
`
begin 600 ucd.pc
M+RI5;FEX($-O;6UA;F0_at_1&%E;6]N"B @=61C+G!C*B\*"B\J"G!R;V,@:6YA
M;64]=61C('5S97)I9#UC9F,O8V9C('-Q;&-H96-K/7-E;6%N=&EC<PHJ+PH*
M(VEN8VQU9&4@/'-T9&EO+F@^"B-I;F-L=61E(#QS=')I;F<N:#X*15A%0R!3
M44P_at_24Y#3%5$12!344Q#03L*15A%0R!344P_at_0D5'24X_at_1$5#3$%212!314-4
M24]..PH*8VAA<B J=6ED(#T@(F-F8R]C9F,B.PII;G0@<W1A='5S.PI605)#
M2$%2(&-O;6UA;F1;,C!=.PI605)#2$%2('9A;'5E6S(P,#!=.PI605)#2$%2
M(')E='5R;E]N86UE6S,P73L*"D5814,@4U%,($5.1"!$14-,05)%(%-%0U1)
M3TX["@IV;VED(&-O;FYE8W1?97)R;W(H*2!["@EC:&%R(&US9U]B=69F97);
M-3$R73L*"6EN="!M<V=?;&5N9W1H.PH):6YT(&)U9F9E<E]S:7IE(#T_at_-3$R
M.PH*"45814,@4U%,(%=(14Y%5D52(%-13$524D]2($-/3E1)3E5%.PH)<W%L
M9VQM*&US9U]B=69F97(L("9B=69F97)?<VEZ92P@)FUS9U]L96YG=&@I.PH)
M<')I;G1F*")$865M;VX_at_97)R;W(@=VAI;&4_at_8V]N;F5C=&EN9SI<;B(I.PH)
M<')I;G1F*"(E+BIS7&XB+"!M<V=?;&5N9W1H+"!M<V=?8G5F9F5R*3L*"7!R
M:6YT9B_at_B1&%E;6]N('%U:71T:6YG+EQN(BD["@EE>&ET*#$I.PI]"@IV;VED
M('-Q;%]E<G)O<B_at_I('L*"6-H87(@;7-G7V)U9F9E<ELU,3)=.PH):6YT(&US
M9U]L96YG=&@["@EI;G0_at_8G5F9F5R7W-I>F4@/2 U,3(["@H)15A%0R!344P@
M5TA%3D5615(@4U%,15)23U(@0T].5$E.544["@D*"7-Q;&=L;2AM<V=?8G5F
M9F5R+" F8G5F9F5R7W-I>F4L("9M<V=?;&5N9W1H*3L*"7!R:6YT9B_at_B1&%E
M;6]N(&5R<F]R('=H:6QE(&5X96-U=&EN9SI<;B(I.PH)<')I;G1F*"(E+BIS
M7&XB+"!M<V=?;&5N9W1H+"!M<V=?8G5F9F5R*3L*"7!R:6YT9B_at_B1&%E;6]N
M(&-O;G1I;G5I;F<N7&XB*3L*?0H*;6%I;B_at_I('L*"45814,@4U%,(%=(14Y%
M5D52(%-13$524D]2($1/(&-O;FYE8W1?97)R;W(H*3L*"45814,@4U%,($-/
M3DY%0U0@.G5I9#L*"7!R:6YT9B_at_B1&%E;6]N(&-O;FYE8W1E9"Y<;B(I.PH)
M15A%0R!344P_at_5TA%3D5615(@4U%,15)23U(@1$\@<W%L7V5R<F]R*"D["@EP
M<FEN=&8H(D1A96UO;B!W86ET:6YG+BXN7&XB*3L*"7=H:6QE("@Q*2!["@D)
M15A%0R!344P_at_15A%0U5410H)"4)%1TE."@D)"3IS=&%T=7,@.CT_at_1$)-4U]0
M25!%+E)%0T5)5D5?34534T%'12_at_G9&%E;6]N)RD["@D)"4E&(#IS=&%T=7,@
M/2 P(%1(14X*"0D)"41"35-?4$E012Y53E!!0TM?34534T%'12_at_Z8V]M;6%N
M9"D["@D)"45.1"!)1CL*"0E%3D0["@D)14Y$+45814,["@H)"6EF("AS=&%T
M=7,@/3T@,"E["@D)"6-O;6UA;F0N87)R6V-O;6UA;F0N;&5N72 ]("=<,"<[
M"@D)"6EF("@A<W1R8VUP*"AC:&%R("HI(&-O;6UA;F0N87)R+" B4U1/4"(I
M*7L*"0D)<')I;G1F*")$865M;VX_at_97AI=&EN9RY<;B(I.PH)"0EB<F5A:SL*
M"0D)?0H)"0EE;'-E(&EF("@A<W1R8VUP*"AC:&%R("HI(&-O;6UA;F0N87)R
M+" B4UE35$5-(BDI>PH)"0D)15A%0R!344P_at_15A%0U5410H)"0D)0D5'24X*
M"0D)"0E$0DU37U!)4$4N54Y004-+7TU%4U-!1T4H.G)E='5R;E]N86UE*3L* M"0D)"0E$0DU37U!)4$4N54Y004-+7TU%4U-!1T4H.G9A;'5E*3L*"0D)"45. M1#L*"0D)"45.1"U%6$5#.PH)"@D)"0EV86QU92YA<G);=F%L=64N;&5N72 ]M("=<,"<["@D)"0EP<FEN=&8H(E=I;&P_at_97AE8W5T92!S>7-T96T_at_8V]M;6%N M9""2)7.27&XB+"!V86QU92YA<G(I.PH)"0D)<W1A='5S(#T@<WES=&5M*'9A M;'5E+F%R<BD["@D)"0E%6$5#(%-13"!%6$5#551%"@D)"0E"14=)3_at_H)"0D) M"41"35-?4$E012Y004-+7TU%4U-!1T4H)V1O;F4G*3L*"0D)"0E$0DU37U!) M4$4N4$%#2U]-15-304=%*#IS=&%T=7,I.PH)"0D)"3IS=&%T=7,@.CT_at_1$)- M4U]025!%+E-%3D1?34534T%'12_at_Z<F5T=7)N7VYA;64I.PH)"0D)14Y$.PH) M"0D)14Y$+45814,["@D)"0EI9B H<W1A='5S*7L*"0D)"0EP<FEN=&8H(D1A M96UO;B!E<G)O<B!W:&EL92!R97-P;VYD:6YG('1O('-Y<W1E;2!C;VUM86YD M+B(I.PH)"0D)"7!R:6YT9B_at_B('-T871U<SH@)61<;B(L('-T871U<RD["@D)
M"0E]"@D)"7T*"0D)96QS92!I9B H(7-T<F-M<"@H8VAA<B J*2!C;VUM86YD M+F%R<BP@(E-13"(I*2!["@D)"0E%6$5#(%-13"!%6$5#551%"@D)"0E"14=) M3_at_H)"0D)1$)-4U]025!%+E5.4$%#2U]-15-304=%*#IR971U<FY?;F%M92D[ M"@D)"0E$0DU37U!)4$4N54Y004-+7TU%4U-!1T4H.G9A;'5E*3L*"0D)"45.M1#L*"0D)"45.1"U%6$5#.PH*"0D)"79A;'5E+F%R<EMV86QU92YL96Y=(#T@ M)UPP)SL*"0D)"7!R:6YT9B_at_B5VEL;"!E>&5C=71E('-Q;"!C;VUM86YD()(E M<Y)<;B(L('9A;'5E+F%R<BD["@D)"0E%6$5#(%-13"!72$5.159%4B!344Q% M4E)/4B!#3TY424Y513L*"0D)"45814,@4U%,($5814-55$4_at_24U-141)051% M(#IV86QU93L*"0D)"7-T871U<R ]('-Q;&-A+G-Q;&-O9&4["@D)"0E%6$5# M(%-13"!72$5.159%4B!344Q%4E)/4B!$3R!S<6Q?97)R;W(H*3L*"0D)"458 M14,@4U%,($5814-55$4*"0D)"4)%1TE."@D)"0D)1$)-4U]025!%+E!!0TM? M34534T%'12_at_G9&]N92<I.PH)"0D)"41"35-?4$E012Y004-+7TU%4U-!1T4H M.G-T871U<RD["@D)"0D).G-T871U<R Z/2!$0DU37U!)4$4N4T5.1%]-15-3 M04=%*#IR971U<FY?;F%M92D["@D)"0E%3D0["@D)"0E%3D0M15A%0SL*"0D) M"6EF("AS=&%T=7,I>PH)"0D)"7!R:6YT9B_at_B1&%E;6]N(&5R<F]R('=H:6QE M(')E<W!O;F1I;F<@=&\@<W%L(&-O;6UA;F0N(BD["@D)"0D)<')I;G1F*"(@ M<W1A='5S.B E9%QN(BP@<W1A='5S*3L*"0D)"7T*"0D)?0H)"0EE;'-E>PH)
M"0D)<')I;G1F*")$865M;VX_at_97)R;W(Z(&EN=F%L:60_at_8V]M;6%N9""2)7.2
M(')E8V5I=F5D+EQN(BQC;VUM86YD+F%R<BD["@D)"7T*"0E]"@D)96QS92![
M"@D)"7!R:6YT9B_at_B1&%E;6]N(&5R<F]R('=H:6QE('=A:71I;F<@9F]R('-I
M9VYA;"XB*3L*"0D)<')I;G1F*"(@<W1A='5S(#T@)61<;B(L('-T871U<RD[
M"@D)?0H)?0H)15A%0R!344P_at_0T]-34E4(%=/4DL_at_4D5,14%313L*"65X:70H
%,"D["GT)
 |
 |