summaryrefslogtreecommitdiff
path: root/ext/oci8/tests/lob_009.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/oci8/tests/lob_009.phpt')
-rw-r--r--ext/oci8/tests/lob_009.phpt69
1 files changed, 0 insertions, 69 deletions
diff --git a/ext/oci8/tests/lob_009.phpt b/ext/oci8/tests/lob_009.phpt
deleted file mode 100644
index b9f7401128..0000000000
--- a/ext/oci8/tests/lob_009.phpt
+++ /dev/null
@@ -1,69 +0,0 @@
---TEST--
-oci_lob_import()/read()
---SKIPIF--
-<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
---FILE--
-<?php
-
-require dirname(__FILE__).'/connect.inc';
-require dirname(__FILE__).'/create_table.inc';
-
-$ora_sql = "INSERT INTO
- ".$schema.$table_name." (blob)
- VALUES (empty_blob())
- RETURNING
- blob
- INTO :v_blob ";
-
-$statement = oci_parse($c,$ora_sql);
-$blob = oci_new_descriptor($c,OCI_D_LOB);
-oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB);
-oci_execute($statement, OCI_DEFAULT);
-
-var_dump($blob);
-var_dump($blob->seek(10, OCI_SEEK_CUR));
-var_dump($blob->import(dirname(__FILE__)."/lob_009.txt"));
-oci_commit($c);
-
-$select_sql = "SELECT blob FROM ".$schema.$table_name." FOR UPDATE";
-$s = oci_parse($c, $select_sql);
-oci_execute($s, OCI_DEFAULT);
-
-var_dump($row = oci_fetch_array($s));
-
-while (!$row[0]->eof()) {
- var_dump($row[0]->read(1024));
-}
-
-require dirname(__FILE__).'/drop_table.inc';
-
-echo "Done\n";
-
-?>
---EXPECTF--
-object(OCI-Lob)#%d (1) {
- ["descriptor"]=>
- resource(%d) of type (oci8 descriptor)
-}
-bool(true)
-bool(true)
-array(2) {
- [0]=>
- object(OCI-Lob)#%d (1) {
- ["descriptor"]=>
- resource(%d) of type (oci8 descriptor)
- }
- ["BLOB"]=>
- object(OCI-Lob)#%d (1) {
- ["descriptor"]=>
- resource(%d) of type (oci8 descriptor)
- }
-}
-string(43) "this
-is
-a
-test
-file for
-test lob_009.phpt
-"
-Done