@@ -23,6 +23,7 @@ $blob = oci_new_descriptor($c,OCI_D_LOB);
2323oci_bind_by_name ($ statement ,":v_blob " , $ blob ,-1 ,OCI_B_BLOB );
2424oci_execute ($ statement , OCI_DEFAULT );
2525
26+ echo "Writing blob \n" ;
2627var_dump ($ blob ->write ("some string here. string, I said " ));
2728oci_commit ($ c );
2829
@@ -54,21 +55,34 @@ $row2 = oci_fetch_array($s);
5455
5556$ dummy = oci_new_descriptor ($ c , OCI_D_LOB );
5657
58+ //--------------------------------------------------
59+
60+ echo "\noci_lob_copy invalid args \n" ;
61+
5762var_dump (oci_lob_copy ($ dummy , $ row1 [0 ]));
5863var_dump (oci_lob_copy ($ row2 [0 ], $ dummy ));
59-
6064var_dump (oci_lob_copy ($ row2 [0 ], $ row1 [0 ], 0 ));
61- var_dump (oci_lob_copy ($ row2 [0 ], $ row1 [0 ], -1 ));
6265var_dump (oci_lob_copy ($ row2 [0 ], $ row1 [0 ], 100000 ));
6366
67+ try {
68+ var_dump (oci_lob_copy ($ row2 [0 ], $ row1 [0 ], -1 ));
69+ } catch (ValueError $ e ) {
70+ echo $ e ->getMessage (), "\n" ;
71+ }
72+
73+ //--------------------------------------------------
74+
75+ echo "\noci_lob_size tests \n" ;
76+
6477var_dump (oci_lob_size ($ row2 [0 ]));
6578unset($ dummy ->descriptor );
6679var_dump (oci_lob_size ($ dummy ));
6780
6881oci_rollback ($ c );
69- oci_rollback ($ c );
70- oci_commit ($ c );
71- oci_commit ($ c );
82+
83+ //--------------------------------------------------
84+
85+ echo "\nQuery test \n" ;
7286
7387$ select_sql = "SELECT blob FROM " .$ schema .$ table_name ." WHERE id = 2 FOR UPDATE " ;
7488$ s = oci_parse ($ c , $ select_sql );
@@ -82,22 +96,27 @@ echo "Done\n";
8296
8397?>
8498--EXPECTF--
99+ Writing blob
85100int(32)
86101
102+ oci_lob_copy invalid args
103+
87104Warning: oci_lob_copy(): OCI_INVALID_HANDLE in %s on line %d
88105bool(false)
89106
90107Warning: oci_lob_copy(): OCI_INVALID_HANDLE in %s on line %d
91108bool(false)
92109bool(false)
93-
94- Warning: oci_lob_copy(): Length parameter must be greater than 0 in %s on line %d
95- bool(false)
96110bool(true)
111+ oci_lob_copy(): Argument #3 ($length) must be greater than or equal to 0
112+
113+ oci_lob_size tests
97114int(0)
98115
99116Warning: oci_lob_size(): Unable to find descriptor property in %s on line %d
100117bool(false)
118+
119+ Query test
101120array(2) {
102121 [0]=>
103122 string(0) ""
0 commit comments