存储过程是这样的
1.
0
573CREATE OR REPLACE PROCEDURE HR.get_job_info_sp (v_job_id OUT varchar2)
IS
BEGIN
SELECT job_id
INTO v_job_id
FROM jobs
WHERE job_id='oooo';
END;
2.
CREATE OR REPLACE PROCEDURE hr.get_job_sp_by_id (c_list OUT sys_refcursor)
IS
BEGIN
OPEN c_list FOR
SELECT job_id
FROM jobs;
END;
现在只知道第一个获取单个out值的怎么写
$result = $conn->prepare("BEGIN get_job_info_sp(:v_job_id); end;");
$result->bindParam(":v_job_id", $v_job_id, PDO::PARAM_STR, 300);
$result->execute();
第二个返回游标的怎么获取？
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
光阴似箭催人老，日月如移越少年。