Lines Matching refs:cur1
32 procedure open_ref_cur(cur1 out refcursortype);
33 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2);
37 procedure open_ref_cur(cur1 out refcursortype) is
39 open cur1 for select * from refcurtest order by c1;
41 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2) is
43 fetch cur1 into c1,c2;
67 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
69 $cur1 = oci_new_cursor($c);
70 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
79 if (!oci_bind_by_name($s2, ":curs1", $cur1, -1, SQLT_RSET)) {
91 $cur1 = oci_new_cursor($c);
93 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
103 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
106 oci_set_prefetch($cur1,5);
108 oci_execute($cur1);
109 var_dump(oci_fetch_row($cur1));
113 $cur1 = oci_new_cursor($c);
114 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
119 oci_execute($cur1);
120 var_dump(oci_fetch_row($cur1));
121 oci_set_prefetch($cur1,5);
122 oci_set_prefetch($cur1,0);
123 oci_set_prefetch($cur1,100);
126 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
