✏️ Editing: define0.phpt

--TEST--
oci_define_by_name()
--SKIPIF--
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php

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

// Initialize

$stmtarray = array(
    "drop table define0_tab",
    "create table define0_tab (string varchar(10))",
    "insert into define0_tab (string) values ('some')",
);

oci8_test_sql_execute($c, $stmtarray);

// Run test

$stmt = oci_parse($c, "select string from define0_tab");

/* the define MUST be done BEFORE ociexecute! */

echo "Test 1\n";

$string = '';
oci_define_by_name($stmt, "STRING", $string, 20);
oci_execute($stmt);
while (oci_fetch($stmt)) {
	var_dump($string);
}

echo "Test 2\n";

$string = '';
$s2 = oci_parse($c, 'select string from define0_tab');
oci_define_by_name($s2, 'STRING', $string);
oci_execute($s2);
while (oci_fetch($s2)) {
    var_dump($string);
}

// Cleanup

$stmtarray = array(
    "drop table define0_tab"
);

oci8_test_sql_execute($c, $stmtarray);

?>
===DONE===
<?php exit(0); ?>
--EXPECTF--
Test 1
string(%d) "some"
Test 2
string(%d) "some"
===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 [✎] [×]