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;
65 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
67 $cur1 = oci_new_cursor($c);
68 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
77 if (!oci_bind_by_name($s2, ":curs1", $cur1, -1, SQLT_RSET)) {
90 oci_execute($cur1);
92 oci_set_prefetch($cur1,0);
94 var_dump(oci_fetch_row($cur1));
101 oci_set_prefetch($cur1,5);
103 var_dump(oci_fetch_row($cur1));
111 $cur1 = oci_new_cursor($c);
112 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
118 oci_execute($cur1);
119 var_dump(oci_fetch_row($cur1));
120 oci_set_prefetch($cur1,5);
123 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
