xref: /PHP-5.6/ext/oci8/tests/lob_015.phpt (revision 8cdefd3d) 
1--TEST--
2various tests with wrong param count
3--SKIPIF--
4<?php
5$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
6require(dirname(__FILE__).'/skipif.inc');
7?>
8--FILE--
9<?php
10
11require dirname(__FILE__).'/connect.inc';
12require dirname(__FILE__).'/create_table.inc';
13
14$ora_sql = "INSERT INTO
15                       ".$schema.$table_name." (blob)
16                      VALUES (empty_blob())
17                      RETURNING
18                               blob
19                      INTO :v_blob ";
20
21$statement = oci_parse($c,$ora_sql);
22$blob = oci_new_descriptor($c,OCI_D_LOB,1,2,3);
23$blob = oci_new_descriptor($c);
24$int = 1;
25oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB,4);
26oci_bind_by_name($statement,":v_blob", $blob,-1,OCI_B_BLOB,4,5);
27oci_bind_by_name($statement,":v_blob", $int,-1);
28oci_bind_by_name($statement,":v_blob", $int);
29oci_bind_by_name($statement,":v_blob");
30oci_bind_by_name($statement);
31oci_execute($statement, OCI_DEFAULT);
32
33var_dump($blob);
34
35require dirname(__FILE__).'/drop_table.inc';
36
37echo "Done\n";
38
39?>
40--EXPECTF--
41Warning: oci_new_descriptor() expects at most 2 parameters, 5 given in %s on line %d
42
43Warning: oci_bind_by_name() expects at most 5 parameters, 6 given in %s on line %d
44
45Warning: oci_bind_by_name() expects at most 5 parameters, 7 given in %s on line %d
46
47Warning: oci_bind_by_name() expects at least 3 parameters, 2 given in %s on line %d
48
49Warning: oci_bind_by_name() expects at least 3 parameters, 1 given in %s on line %d
50
51Warning: oci_execute(): ORA-00932: %s on line %d
52object(OCI-Lob)#%d (1) {
53  ["descriptor"]=>
54  resource(%d) of type (oci8 descriptor)
55}
56Done
57