oci.sql

来自「使用Oracle 外部過程發送email, 有裝java組件的Oracle不需」· SQL 代码 · 共 17 行

create or replace library sendmaillibrary as
'c:\\winnt\system32\oraclesmtp.dll' ;
/
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) ;