diff options
Diffstat (limited to 'ext/oci8/tests/refcur_prefetch_1.phpt')
| -rw-r--r-- | ext/oci8/tests/refcur_prefetch_1.phpt | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/ext/oci8/tests/refcur_prefetch_1.phpt b/ext/oci8/tests/refcur_prefetch_1.phpt index 1f00b9b031..911a481063 100644 --- a/ext/oci8/tests/refcur_prefetch_1.phpt +++ b/ext/oci8/tests/refcur_prefetch_1.phpt @@ -23,25 +23,25 @@ require(__DIR__."/connect.inc"); // Creates the necessary package and tables. $stmtarray = array( - "DROP TABLE refcurtest", - "CREATE TABLE refcurtest (c1 NUMBER, c2 VARCHAR(20))", + "DROP TABLE refcurtest", + "CREATE TABLE refcurtest (c1 NUMBER, c2 VARCHAR(20))", "CREATE or REPLACE PACKAGE refcurpkg is type refcursortype is ref cursor; procedure open_ref_cur(cur1 out refcursortype); procedure fetch_ref_cur(cur1 in refcursortype, c1 out number,c2 out varchar2); end refcurpkg;", "CREATE or REPLACE PACKAGE body refcurpkg is - procedure open_ref_cur(cur1 out refcursortype) is + procedure open_ref_cur(cur1 out refcursortype) is begin - open cur1 for select * from refcurtest order by c1; - end open_ref_cur; - procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, - c2 out varchar2) is - begin - fetch cur1 into c1,c2; - end fetch_ref_cur; + open cur1 for select * from refcurtest order by c1; + end open_ref_cur; + procedure fetch_ref_cur(cur1 in refcursortype, c1 out number, + c2 out varchar2) is + begin + fetch cur1 into c1,c2; + end fetch_ref_cur; end refcurpkg;" - ); + ); oci8_test_sql_execute($c, $stmtarray); |