Lines Matching refs:cur1
25 procedure open_ref_cur(cur1 out refcursortype);
26 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2);
30 procedure open_ref_cur(cur1 out refcursortype) is
32 open cur1 for select * from refcurtest order by c1;
34 procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, c2 out varchar2) is
36 fetch cur1 into c1,c2;
60 $sql1 = "begin refcurpkg.open_ref_cur(:cur1); end;";
62 $cur1 = oci_new_cursor($c);
63 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
72 if (!oci_bind_by_name($s2, ":curs1", $cur1, -1, SQLT_RSET)) {
84 $cur1 = oci_new_cursor($c);
86 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
96 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
99 oci_set_prefetch($cur1,5);
101 oci_execute($cur1);
102 var_dump(oci_fetch_row($cur1));
106 $cur1 = oci_new_cursor($c);
107 if (!oci_bind_by_name($s1,":cur1",$cur1,-1,SQLT_RSET)) {
112 oci_execute($cur1);
113 var_dump(oci_fetch_row($cur1));
114 oci_set_prefetch($cur1,5);
115 oci_set_prefetch($cur1,0);
116 oci_set_prefetch($cur1,100);
119 if (!oci_bind_by_name($s2,":curs1",$cur1,-1,SQLT_RSET)) {
