|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2009-09-09 07:56 UTC] hymanyung at 163 dot com
[2009-09-09 08:43 UTC] jani@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 06:00:02 2025 UTC |
Description: ------------ I want to pass a date type variable into oracle's procedure. But It automate converts date type into string. Reproduce code: --------------- $sql = 'declare ws_time date := :mydate; begin select con_id from home.zcontp00; end; $stmt = oci_parse($this->conn, $sql); $my_cursor = ociNewCursor($this->conn); $now = date('Y-m-d',strtotime('2009-09-08')); OCIBindByName($stmt, ":mydate",$now); OCIBindByName($stmt, ":c1", $my_cursor, -1, OCI_B_CURSOR); OCIExecute($stmt); OCIExecute($my_cursor); while ($val = oci_fetch_assoc($my_cursor)){ echo $val['CON_ID']; } Expected result: ---------------- Above Report error. " literal does not match format string "