From b0885bb9a2757fe9293c4bd62461f97c194f8e37 Mon Sep 17 00:00:00 2001
From: Christopher Jones <sixd@php.net>
Date: Thu, 5 Jun 2008 23:28:16 +0000
Subject: [PATCH] MFH: Make tests interruptible; clean up tables at start

---
 ext/oci8/tests/define2.phpt | 13 ++++++++++---
 ext/oci8/tests/define3.phpt | 15 +++++++++++----
 2 files changed, 21 insertions(+), 7 deletions(-)

diff --git a/ext/oci8/tests/define2.phpt b/ext/oci8/tests/define2.phpt
index e8c5f8a99a..46e11bf886 100644
--- a/ext/oci8/tests/define2.phpt
+++ b/ext/oci8/tests/define2.phpt
@@ -5,10 +5,17 @@ Test oci_define_by_name types
 --FILE--
 <?php
 
-require dirname(__FILE__)."/connect.inc";
+require(dirname(__FILE__)."/connect.inc");
 
-$stmt = oci_parse($c, "create table phptestrawtable( id number(10), fileimage raw(1000))");
-oci_execute($stmt);
+$stmtarray = array(
+	"drop table phptestrawtable",
+	"create table phptestrawtable( id number(10), fileimage raw(1000))"
+);
+						 
+foreach ($stmtarray as $stmt) {
+	$s = oci_parse($c, $stmt);
+	@oci_execute($s);
+}
 
 $stmt = oci_parse ($c, "insert into phptestrawtable (id, fileimage) values (:id, :fileimage)");
 $i=1;
diff --git a/ext/oci8/tests/define3.phpt b/ext/oci8/tests/define3.phpt
index d30db637cd..892e8e3809 100644
--- a/ext/oci8/tests/define3.phpt
+++ b/ext/oci8/tests/define3.phpt
@@ -5,10 +5,17 @@ Test oci_define_by_name() LOB descriptor
 --FILE--
 <?php
 
-require dirname(__FILE__)."/connect.inc";
-
-$stmt = oci_parse($c, "create table phpdefblobtable( id number(10), fileimage blob)");
-oci_execute($stmt);
+require(dirname(__FILE__)."/connect.inc");
+
+$stmtarray = array(
+	"drop table phpdefblobtable",
+	"create table phpdefblobtable (id number(10), fileimage blob)"
+);
+						 
+foreach ($stmtarray as $stmt) {
+	$s = oci_parse($c, $stmt);
+	@oci_execute($s);
+}
 
 // Load data
 $stmt = oci_parse ($c, "insert into phpdefblobtable (id, fileimage) values (:id, empty_blob()) returning fileimage into :fileimage");
-- 
2.50.1