存储过程是这样的
1.
create or replace procedure hr.get_job_info_sp (v_job_id out varchar2)isbegin 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)isbegin 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();

第二个返回游标的怎么获取？
回复内容： 存储过程是这样的
1.
create or replace procedure hr.get_job_info_sp (v_job_id out varchar2)isbegin 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)isbegin 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();

第二个返回游标的怎么获取？