Lines Matching refs:cur1
30 procedure open_ref_cur(cur1 out refcursortype);
31 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number,c2 out varchar2);
34 procedure open_ref_cur(cur1 out refcursortype) is
36 open cur1 for select * from refcurtest order by c1;
38 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number,
41 fetch cur1 into c1,c2;
69 $cur1 = oci_new_cursor($c);
70 fetch_frm_php($c,$cur1,$value);
71 fetch_frm_plsql($c,$cur1);
81 $cur1 = oci_new_cursor($c);
82 fetch_frm_php($c,$cur1,$value);
83 fetch_frm_plsql($c,$cur1);
92 function fetch_frm_php($c,$cur1,$value) {
93 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
95 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
99 oci_set_prefetch($cur1,$value);
100 oci_execute($cur1);
102 var_dump(oci_fetch_row($cur1));
107 function fetch_frm_plsql($c,$cur1) {
110 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
