PHP代码如下:

public function index()
        {
            $num = 3;
            @$sql = "call TTTT('$num')";
            $this->db04->query($sql);                    
        }

        public function indexxx()
        {
           header("Content-type: text/html; charset=utf-8");
           $conn = oci_connect('user','password',"(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST=xxxxxxxxxx)(PORT = 1521))(CONNECT_DATA =(SID=xxxxx)))");
           if($conn){
                   echo '连接上';
           }else{
                   echo '未连接';
           }
            $sql = 'BEGIN TTTT(:num); END;';
            $stmt = oci_parse($conn,$sql);    
            oci_bind_by_name($stmt,':num',$num,32); //绑定参数       
            $num = '2';
            oci_execute($stmt);            
        }

Oracle procedure代码如下:

create or replace PROCEDURE TTTT(num number)
AS
BEGIN
    DELETE FROM TEST T
    WHERE T.THEDATE=TO_CHAR(SYSDATE-NUM,'YYYY-MM-DD');
    
    INSERT INTO  TEST(THEDATE,ACCOUNT_CNT,DEVICE_CNT,CHANNELID,GAMEID,LOADTIME)
    SELECT TO_CHAR(SYSDATE-NUM,'YYYY-MM-DD') AS REGDATE,
           COUNT(SN.ACCOUNTID),
           COUNT(DISTINCT SN.DEVICEID),
           SN.CHANNELID,
           SN.GAMEID,
           SYSDATE
    FROM SDK_NEWUSER SN
    WHERE SN.NEWDATE=TO_CHAR(SYSDATE-NUM,'YYYY-MM-DD')
    GROUP BY SN.CHANNELID,
             SN.GAMEID;
    COMMIT;     
END TTTT;