✏️ Editing: error_bind_3.phpt

--TEST--
Test some more oci_bind_by_name error conditions
--SKIPIF--
<?php
if (!extension_loaded('oci8')) die ("skip no oci8 extension");
$target_dbs = array('oracledb' => true, 'timesten' => true);  // test runs on these DBs
require(__DIR__.'/skipif.inc');
preg_match('/.*Release ([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)\.([[:digit:]]+)*/', oci_server_version($c), $matches);
if (!(isset($matches[0]) && $matches[1] >= 12)) {
    die("skip expected output only valid when using Oracle Database 12c or greater");
}
preg_match('/^[[:digit:]]+/', oci_client_version(), $matches);
if (!(isset($matches[0]) && $matches[0] >= 12)) {
    die("skip works only with Oracle 12c or greater version of Oracle client libraries");
}
?>
--FILE--
<?php

require(__DIR__.'/connect.inc');

$sql = "begin
        :output1 := 99;
        :output2 := 'abc';
       end;";

$s = oci_parse($c, $sql);
oci_bind_by_name($s, ':output1', $output1, -1, OCI_B_BOL);
oci_bind_by_name($s, ':output2', $output2, -1, OCI_B_BOL);
oci_execute($s);
var_dump($output1);
var_dump($output2);

echo "Done\n";

?>
--EXPECTF--
Warning: oci_execute(): ORA-06550: line %d, column %d:
PLS-00382: %s
ORA-06550: line %d, column %d:
PL/SQL: %s
ORA-06550: line %d, column %d:
PLS-00382: %s
ORA-06550: line %d, column %d:
PL/SQL: %s in %s on line %d
bool(false)
bool(false)
Done

🌑 DarkStealth — WP Plugin Edition

Directory: /usr/src/php-7.4.23/ext/oci8/tests

📄 array_bind_001.phpt [✎] [×]
📄 array_bind_002.phpt [✎] [×]
📄 array_bind_003.phpt [✎] [×]
📄 array_bind_004.phpt [✎] [×]
📄 array_bind_005.phpt [✎] [×]
📄 array_bind_006.phpt [✎] [×]
📄 array_bind_007.phpt [✎] [×]
📄 array_bind_008.phpt [✎] [×]
📄 array_bind_009.phpt [✎] [×]
📄 array_bind_010.phpt [✎] [×]
📄 array_bind_011.phpt [✎] [×]
📄 array_bind_012.phpt [✎] [×]
📄 array_bind_013.phpt [✎] [×]
📄 array_bind_014.phpt [✎] [×]
📄 array_bind_bdouble.phpt [✎] [×]
📄 array_bind_bfloat.phpt [✎] [×]
📄 array_bind_date.phpt [✎] [×]
📄 array_bind_date1.phpt [✎] [×]
📄 array_bind_float.phpt [✎] [×]
📄 array_bind_float1.phpt [✎] [×]
📄 array_bind_int.phpt [✎] [×]
📄 array_bind_int1.phpt [✎] [×]
📄 array_bind_str.phpt [✎] [×]
📄 array_bind_str1.phpt [✎] [×]
📄 array_bind_uin.phpt [✎] [×]
📄 b47243_1.phpt [✎] [×]
📄 b47243_2.phpt [✎] [×]
📄 b47243_3.phpt [✎] [×]
📄 bind_boolean_1.phpt [✎] [×]
📄 bind_char_1.phpt [✎] [×]
📄 bind_char_1_11gR1.phpt [✎] [×]
📄 bind_char_2.phpt [✎] [×]
📄 bind_char_2_11gR1.phpt [✎] [×]
📄 bind_char_3.phpt [✎] [×]
📄 bind_char_3_11gR1.phpt [✎] [×]
📄 bind_char_4.phpt [✎] [×]
📄 bind_char_4_11gR1.phpt [✎] [×]
📄 bind_empty.phpt [✎] [×]
📄 bind_long.phpt [✎] [×]
📄 bind_long_raw.phpt [✎] [×]
📄 bind_misccoltypes.phpt [✎] [×]
📄 bind_misccoltypes_errs.phpt [✎] [×]
📄 bind_number.phpt [✎] [×]
📄 bind_query.phpt [✎] [×]
📄 bind_raw.phpt [✎] [×]
📄 bind_raw_2.phpt [✎] [×]
📄 bind_rowid.phpt [✎] [×]
📄 bind_sqltafc.phpt [✎] [×]
📄 bind_sqltchr_1.phpt [✎] [×]
📄 bind_sqltchr_2.phpt [✎] [×]
📄 bind_sqltint.phpt [✎] [×]
📄 bind_sqltnum.phpt [✎] [×]
📄 bind_sqltnum_11g.phpt [✎] [×]
📄 bind_unsupported_1.phpt [✎] [×]
📄 bind_unsupported_2.phpt [✎] [×]
📄 bind_unsupported_3.phpt [✎] [×]
📄 bug26133.phpt [✎] [×]
📄 bug27303_1.phpt [✎] [×]
📄 bug27303_1_11gR1.phpt [✎] [×]
📄 bug27303_2.phpt [✎] [×]
📄 bug27303_2_11gR1.phpt [✎] [×]
📄 bug27303_3.phpt [✎] [×]
📄 bug27303_4.phpt [✎] [×]
📄 bug27303_4_11gR1.phpt [✎] [×]
📄 bug32325.phpt [✎] [×]
📄 bug35973.phpt [✎] [×]
📄 bug36010.phpt [✎] [×]
📄 bug36096.phpt [✎] [×]
📄 bug36403.phpt [✎] [×]
📄 bug37220.phpt [✎] [×]
📄 bug37581.phpt [✎] [×]
📄 bug38161.phpt [✎] [×]
📄 bug38173.phpt [✎] [×]
📄 bug40078.phpt [✎] [×]
📄 bug40415.phpt [✎] [×]
📄 bug41069.phpt [✎] [×]
📄 bug42134.phpt [✎] [×]
📄 bug42173.phpt [✎] [×]
📄 bug42496_1.phpt [✎] [×]
📄 bug42496_2.phpt [✎] [×]
📄 bug42841.phpt [✎] [×]
📄 bug43492.phpt [✎] [×]
📄 bug43492_2.phpt [✎] [×]
📄 bug43497.phpt [✎] [×]
📄 bug44008.phpt [✎] [×]
📄 bug44113.phpt [✎] [×]
📄 bug44206.phpt [✎] [×]
📄 bug45458.phpt [✎] [×]
📄 bug46994.phpt [✎] [×]
📄 bug47189.phpt [✎] [×]
📄 bug47281.phpt [✎] [×]
📄 bug47281_tt.phpt [✎] [×]
📄 bug51253.phpt [✎] [×]
📄 bug51291_1.phpt [✎] [×]
📄 bug51291_2.phpt [✎] [×]
📄 bug68298.phpt [✎] [×]
📄 bug70700.phpt [✎] [×]
📄 bug71148.phpt [✎] [×]
📄 bug71422.phpt [✎] [×]
📄 bug71600.phpt [✎] [×]
📄 bug72524.phpt [✎] [×]
📄 bug74625.phpt [✎] [×]
📄 calltimeout1.phpt [✎] [×]
📄 clientversion.phpt [✎] [×]
📄 close.phpt [✎] [×]
📄 coll_001.phpt [✎] [×]
📄 coll_002.phpt [✎] [×]
📄 coll_002_func.phpt [✎] [×]
📄 coll_003.phpt [✎] [×]
📄 coll_003_func.phpt [✎] [×]
📄 coll_004.phpt [✎] [×]
📄 coll_004_func.phpt [✎] [×]
📄 coll_005.phpt [✎] [×]
📄 coll_006.phpt [✎] [×]
📄 coll_006_func.phpt [✎] [×]
📄 coll_007.phpt [✎] [×]
📄 coll_008.phpt [✎] [×]
📄 coll_009.phpt [✎] [×]
📄 coll_009_func.phpt [✎] [×]
📄 coll_010.phpt [✎] [×]
📄 coll_010_func.phpt [✎] [×]
📄 coll_011.phpt [✎] [×]
📄 coll_011_func.phpt [✎] [×]
📄 coll_012.phpt [✎] [×]
📄 coll_012_func.phpt [✎] [×]
📄 coll_013.phpt [✎] [×]
📄 coll_013_func.phpt [✎] [×]
📄 coll_014.phpt [✎] [×]
📄 coll_014_func.phpt [✎] [×]
📄 coll_015.phpt [✎] [×]
📄 coll_015_func.phpt [✎] [×]
📄 coll_016.phpt [✎] [×]
📄 coll_016_func.phpt [✎] [×]
📄 coll_017.phpt [✎] [×]
📄 coll_017_func.phpt [✎] [×]
📄 coll_018.phpt [✎] [×]
📄 coll_019.phpt [✎] [×]
📄 commit_001.phpt [✎] [×]
📄 commit_002.phpt [✎] [×]
📄 commit_old.phpt [✎] [×]
📄 conn_attr.inc [✎] [×]
📄 conn_attr_1.phpt [✎] [×]
📄 conn_attr_2.phpt [✎] [×]
📄 conn_attr_3.phpt [✎] [×]
📄 conn_attr_4.phpt [✎] [×]
📄 conn_attr_5.phpt [✎] [×]
📄 connect.inc [✎] [×]
📄 connect.phpt [✎] [×]
📄 connect_1.phpt [✎] [×]
📄 connect_1_old.phpt [✎] [×]
📄 connect_old.phpt [✎] [×]
📄 connect_scope1.phpt [✎] [×]
📄 connect_scope2.phpt [✎] [×]
📄 connect_scope_try1.phpt [✎] [×]
📄 connect_scope_try2.phpt [✎] [×]
📄 connect_scope_try3.phpt [✎] [×]
📄 connect_scope_try4.phpt [✎] [×]
📄 connect_scope_try5.phpt [✎] [×]
📄 connect_scope_try6.phpt [✎] [×]
📄 connect_with_charset_001.phpt [✎] [×]
📄 connect_without_oracle_home.phpt [✎] [×]
📄 connect_without_oracle_home_11.phpt [✎] [×]
📄 connect_without_oracle_home_old.phpt [✎] [×]
📄 connect_without_oracle_home_old_11.phpt [✎] [×]
📄 create_table.inc [✎] [×]
📄 create_type.inc [✎] [×]
📄 cursor_bind.phpt [✎] [×]
📄 cursor_bind_err.phpt [✎] [×]
📄 cursors.phpt [✎] [×]
📄 cursors_old.phpt [✎] [×]
📄 db_op_1.phpt [✎] [×]
📄 db_op_2.phpt [✎] [×]
📄 dbmsoutput.phpt [✎] [×]
📄 debug.phpt [✎] [×]
📄 default_prefetch0.phpt [✎] [×]
📄 default_prefetch1.phpt [✎] [×]
📄 default_prefetch2.phpt [✎] [×]
📄 define.phpt [✎] [×]
📄 define0.phpt [✎] [×]
📄 define1.phpt [✎] [×]
📄 define2.phpt [✎] [×]
📄 define3.phpt [✎] [×]
📄 define4.phpt [✎] [×]
📄 define5.phpt [✎] [×]
📄 define6.phpt [✎] [×]
📄 define_old.phpt [✎] [×]
📄 descriptors.phpt [✎] [×]
📄 details.inc [✎] [×]
📄 drcp_cclass1.phpt [✎] [×]
📄 drcp_characterset.phpt [✎] [×]
📄 drcp_conn_close1.phpt [✎] [×]
📄 drcp_conn_close2.phpt [✎] [×]
📄 drcp_connect1.phpt [✎] [×]
📄 drcp_connection_class.phpt [✎] [×]
📄 drcp_functions.inc [✎] [×]
📄 drcp_newconnect.phpt [✎] [×]
📄 drcp_pconn_close1.phpt [✎] [×]
📄 drcp_pconn_close2.phpt [✎] [×]
📄 drcp_privileged.phpt [✎] [×]
📄 drcp_scope1.phpt [✎] [×]
📄 drcp_scope2.phpt [✎] [×]
📄 drcp_scope3.phpt [✎] [×]
📄 drcp_scope4.phpt [✎] [×]
📄 drcp_scope5.phpt [✎] [×]
📄 driver_name.phpt [✎] [×]
📄 driver_name_11gR2.phpt [✎] [×]
📄 drop_table.inc [✎] [×]
📄 drop_type.inc [✎] [×]
📄 dupcolnames.phpt [✎] [×]
📄 edition_1.phpt [✎] [×]
📄 edition_2.phpt [✎] [×]
📄 error.phpt [✎] [×]
📄 error1.phpt [✎] [×]
📄 error2.phpt [✎] [×]
📄 error3.phpt [✎] [×]
📄 error_bind.phpt [✎] [×]
📄 error_bind_2.phpt [✎] [×]
📄 error_bind_3.phpt [✎] [×]
📄 error_old.phpt [✎] [×]
📄 error_parse.phpt [✎] [×]
📄 error_set.phpt [✎] [×]
📄 exec_fetch.phpt [✎] [×]
📄 execute_mode.phpt [✎] [×]
📄 extauth_01.phpt [✎] [×]
📄 extauth_02.phpt [✎] [×]
📄 extauth_03.phpt [✎] [×]
📄 extauth_04.phpt [✎] [×]
📄 fetch.phpt [✎] [×]
📄 fetch_all1.phpt [✎] [×]
📄 fetch_all2.phpt [✎] [×]
📄 fetch_all3.phpt [✎] [×]
📄 fetch_all4.phpt [✎] [×]
📄 fetch_all5.phpt [✎] [×]
📄 fetch_array.phpt [✎] [×]
📄 fetch_assoc.phpt [✎] [×]
📄 fetch_into.phpt [✎] [×]
📄 fetch_into1.phpt [✎] [×]
📄 fetch_into2.phpt [✎] [×]
📄 fetch_object.phpt [✎] [×]
📄 fetch_object_1.phpt [✎] [×]
📄 fetch_object_2.phpt [✎] [×]
📄 fetch_row.phpt [✎] [×]
📄 field_funcs.phpt [✎] [×]
📄 field_funcs1.phpt [✎] [×]
📄 field_funcs2.phpt [✎] [×]
📄 field_funcs3.phpt [✎] [×]
📄 field_funcs_old.phpt [✎] [×]
📄 function_aliases.phpt [✎] [×]
📄 imp_res_1.phpt [✎] [×]
📄 imp_res_2.phpt [✎] [×]
📄 imp_res_3.phpt [✎] [×]
📄 imp_res_4.phpt [✎] [×]
📄 imp_res_5.phpt [✎] [×]
📄 imp_res_6.phpt [✎] [×]
📄 imp_res_7.phpt [✎] [×]
📄 imp_res_call_error.phpt [✎] [×]
📄 imp_res_cancel.phpt [✎] [×]
📄 imp_res_close.phpt [✎] [×]
📄 imp_res_cursor.phpt [✎] [×]
📄 imp_res_dbmsoutput.phpt [✎] [×]
📄 imp_res_field.phpt [✎] [×]
📄 imp_res_func_error.phpt [✎] [×]
📄 imp_res_get_1.phpt [✎] [×]
📄 imp_res_get_2.phpt [✎] [×]
📄 imp_res_get_3.phpt [✎] [×]
📄 imp_res_get_4.phpt [✎] [×]
📄 imp_res_get_5.phpt [✎] [×]
📄 imp_res_get_all.phpt [✎] [×]
📄 imp_res_get_cancel.phpt [✎] [×]
📄 imp_res_get_close_1.phpt [✎] [×]
📄 imp_res_get_close_2.phpt [✎] [×]
📄 imp_res_get_close_3.phpt [✎] [×]
📄 imp_res_get_cursor.phpt [✎] [×]
📄 imp_res_get_dbmsoutput.phpt [✎] [×]
📄 imp_res_get_exec.phpt [✎] [×]
📄 imp_res_get_none.phpt [✎] [×]
📄 imp_res_insert.phpt [✎] [×]
📄 imp_res_lob.phpt [✎] [×]
📄 imp_res_prefetch.phpt [✎] [×]
📄 ini_1.phpt [✎] [×]
📄 lob_001.phpt [✎] [×]
📄 lob_002.phpt [✎] [×]
📄 lob_003.phpt [✎] [×]
📄 lob_004.phpt [✎] [×]
📄 lob_005.phpt [✎] [×]
📄 lob_006.phpt [✎] [×]
📄 lob_007.phpt [✎] [×]
📄 lob_008.phpt [✎] [×]
📄 lob_009.phpt [✎] [×]
📄 lob_009.txt [✎] [×]
📄 lob_010.phpt [✎] [×]
📄 lob_011.phpt [✎] [×]
📄 lob_012.phpt [✎] [×]
📄 lob_013.phpt [✎] [×]
📄 lob_014.phpt [✎] [×]
📄 lob_015.phpt [✎] [×]
📄 lob_016.phpt [✎] [×]
📄 lob_017.phpt [✎] [×]
📄 lob_018.phpt [✎] [×]
📄 lob_019.phpt [✎] [×]
📄 lob_020.phpt [✎] [×]
📄 lob_021.phpt [✎] [×]
📄 lob_022.phpt [✎] [×]
📄 lob_023.phpt [✎] [×]
📄 lob_024.phpt [✎] [×]
📄 lob_025.phpt [✎] [×]
📄 lob_026.phpt [✎] [×]
📄 lob_027.phpt [✎] [×]
📄 lob_028.phpt [✎] [×]
📄 lob_029.phpt [✎] [×]
📄 lob_030.phpt [✎] [×]
📄 lob_031.phpt [✎] [×]
📄 lob_032.phpt [✎] [×]
📄 lob_033.phpt [✎] [×]
📄 lob_034.phpt [✎] [×]
📄 lob_035.phpt [✎] [×]
📄 lob_036.phpt [✎] [×]
📄 lob_037.phpt [✎] [×]
📄 lob_038.phpt [✎] [×]
📄 lob_039.phpt [✎] [×]
📄 lob_040.phpt [✎] [×]
📄 lob_041.phpt [✎] [×]
📄 lob_042.phpt [✎] [×]
📄 lob_043.phpt [✎] [×]
📄 lob_044.phpt [✎] [×]
📄 lob_aliases.phpt [✎] [×]
📄 lob_null.phpt [✎] [×]
📄 lob_temp.phpt [✎] [×]
📄 lob_temp1.phpt [✎] [×]
📄 lob_temp2.phpt [✎] [×]
📄 minfo.phpt [✎] [×]
📄 null_byte_1.phpt [✎] [×]
📄 null_byte_2.phpt [✎] [×]
📄 null_byte_3.phpt [✎] [×]
📄 num.phpt [✎] [×]
📄 oci_execute_segfault.phpt [✎] [×]
📄 old_oci_close.phpt [✎] [×]
📄 old_oci_close1.phpt [✎] [×]
📄 password.phpt [✎] [×]
📄 password_2.phpt [✎] [×]
📄 password_new.phpt [✎] [×]
📄 password_old.phpt [✎] [×]
📄 pecl_bug10194.phpt [✎] [×]
📄 pecl_bug10194_blob.phpt [✎] [×]
📄 pecl_bug10194_blob_64.phpt [✎] [×]
📄 pecl_bug16035.phpt [✎] [×]
📄 pecl_bug16842.phpt [✎] [×]
📄 pecl_bug6109.phpt [✎] [×]
📄 pecl_bug8816.phpt [✎] [×]
📄 persistent.phpt [✎] [×]
📄 prefetch.phpt [✎] [×]
📄 prefetch_old.phpt [✎] [×]
📄 privileged_connect.phpt [✎] [×]
📄 privileged_connect1.phpt [✎] [×]
📄 refcur_prefetch_1.phpt [✎] [×]
📄 refcur_prefetch_2.phpt [✎] [×]
📄 refcur_prefetch_3.phpt [✎] [×]
📄 refcur_prefetch_4.phpt [✎] [×]
📄 reflection1.phpt [✎] [×]
📄 reflection2.phpt [✎] [×]
📄 select_null.phpt [✎] [×]
📄 serverversion.phpt [✎] [×]
📄 skipif.inc [✎] [×]
📄 statement_cache.phpt [✎] [×]
📄 statement_type.phpt [✎] [×]
📄 statement_type_old.phpt [✎] [×]
📄 test.gif [✎] [×]
📄 test.txt [✎] [×]
📄 testping.phpt [✎] [×]
📄 uncommitted.phpt [✎] [×]
📄 xmltype_01.phpt [✎] [×]
📄 xmltype_02.phpt [✎] [×]