oci.sql

使用Oracle 外部過程發送email, 有裝java組件的Oracle不需要.

create or replace library sendmaillibrary as
'/home/oracle/sendmail.so' ;
/
create or replace  procedure sendmailc (
P_SUBJECT IN VARCHAR2,
P_Message IN VARCHAR2,
P_From    IN VARCHAR2,
p_Recipient IN VARCHAR2)
as external
LIBRARY sendmaillibrary
name "sendMail"
parameters (p_subject STRING,
            p_Message STRING,
            P_From    String,
            P_recipient STRING) ;