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;
58 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
60 $cur1 = oci_new_cursor($c);
61 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
70 if (!oci_bind_by_name($s2, ":curs1", $cur1, -1, SQLT_RSET)) {
83 oci_execute($cur1);
85 oci_set_prefetch($cur1,0);
87 var_dump(oci_fetch_row($cur1));
94 oci_set_prefetch($cur1,5);
96 var_dump(oci_fetch_row($cur1));
104 $cur1 = oci_new_cursor($c);
105 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
111 oci_execute($cur1);
112 var_dump(oci_fetch_row($cur1));
113 oci_set_prefetch($cur1,5);
116 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
