|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2011-12-29 11:37 UTC] 935c at itsynergy dot co dot uk
[2011-12-29 13:47 UTC] 935c at itsynergy dot co dot uk
[2011-12-29 13:47 UTC] 935c at itsynergy dot co dot uk
-PHP Version: Irrelevant
+PHP Version: 5.3.8
[2012-01-27 00:20 UTC] sixd@php.net
[2012-01-27 00:20 UTC] sixd@php.net
-Status: Open
+Status: Feedback
[2012-02-23 21:47 UTC] sixd@php.net
-Assigned To:
+Assigned To: sixd
[2012-10-26 05:18 UTC] sixd@php.net
-Status: Feedback
+Status: No Feedback
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 20:00:01 2025 UTC |
Description: ------------ I am seeing the following errors generated for no apparent reason when a function is used as a string source: PHP Warning: oci_bind_by_name(): Invalid variable used for bind PHP Warning: oci_execute(): ORA-01008: not all variables bound If I replace the $sim_token parameter in my FS_ORA_NEW_SIMTOKEN call with a static string, e.g. "2", then it all works fine. Test script: --------------- -- The OCI8 Call -- function FS_ORA_NEW_SIMTOKEN($p_sess,$p_tkn) { $c = FS_ORA_CONNECT(); $s = oci_parse($c, "begin fs_pkg_XXXXX.new_auth(:p_sess,:p_sim);end;"); oci_bind_by_name($s,":p_sess",$p_sess,-1,SQLT_CHR); oci_bind_by_name($s,":p_sim",$p_tkn,-1,SQLT_CHR); $exec_status=oci_execute($s); oci_free_statement($s); return $exec_status; } -- The Token Generator-- function FS_SIMAPI_GETTOKEN() { $valid_time=time()+FS_SIM_TOKLEN; $sesskey=htmlspecialchars(sha1(XXXXXXXXXXXXX)); $qry_array=array( 'mode' => 'AUTH', 'user' => FS_SIM_UNA, 'clientip'=>FS_SIM_SRCIP, 'expiry' => $valid_time, 'key' => $sesskey ); $tokres=FS_SIMAPI_SIMPLEPOST("XXXXXXX AUTH",$qry_array); if ($tokres==false) { return false; } libxml_use_internal_errors(true); try { $xmlp=new SimpleXMLElement($tokres); } catch (Exception $e) { foreach(libxml_get_errors() as $error_line) { $error_msg = "SimpleXML: ".$error_line->message; FS_APPTOOL_LOGERR($error_msg); } return false; } return $xmlp->results->token; } -- The Application Call-- // 4 XXXXXX Token $sim_token=FS_SIMAPI_GETTOKEN(); if($sim_token!=false) { $sim_to_db=FS_ORA_NEW_SIMTOKEN($_COOKIE['fs_cookie'],$sim_token); if($sim_to_db==false) { header("Location: " . FS_APP_HOME_URI . "?autherr=" . urlencode(FS_ERR_SIMFAIL)); exit; } } else { header("Location: " . FS_APP_HOME_URI . "?autherr=" . urlencode($sim_token)); exit; }