Lines Matching refs:cur1
23 procedure open_ref_cur(cur1 out refcursortype);
24 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number,c2 out varchar2);
27 procedure open_ref_cur(cur1 out refcursortype) is
29 open cur1 for select * from refcurtest order by c1;
31 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number,
34 fetch cur1 into c1,c2;
62 $cur1 = oci_new_cursor($c);
63 fetch_frm_php($c,$cur1,$value);
64 fetch_frm_plsql($c,$cur1);
70 function fetch_frm_php($c,$cur1,$value) {
71 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
73 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
77 oci_set_prefetch($cur1,$value);
78 oci_execute($cur1);
80 var_dump(oci_fetch_row($cur1));
85 function fetch_frm_plsql($c,$cur1) {
88 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
