Lines Matching refs:cur1
34 procedure open_ref_cur(cur1 out refcursortype);
35 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2);
39 procedure open_ref_cur(cur1 out refcursortype) is
41 open cur1 for select * from refcurtest order by c1;
43 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2) is
45 fetch cur1 into c1,c2;
69 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
71 $cur1 = oci_new_cursor($c);
72 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
81 if (!oci_bind_by_name($s2, ":curs1", $cur1, -1, SQLT_RSET)) {
93 $cur1 = oci_new_cursor($c);
95 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
105 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
108 oci_set_prefetch($cur1,5);
110 oci_execute($cur1);
111 var_dump(oci_fetch_row($cur1));
115 $cur1 = oci_new_cursor($c);
116 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
121 oci_execute($cur1);
122 var_dump(oci_fetch_row($cur1));
123 oci_set_prefetch($cur1,5);
124 oci_set_prefetch($cur1,0);
125 oci_set_prefetch($cur1,100);
128 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
