note 33507 added to function.ocibindbyname

From: Date: Sat, 28 Jun 2003 02:08:56 +0000
Subject: note 33507 added to function.ocibindbyname
Groups: php.notes 
Request: Send a blank email to php-notes+get-51120@lists.php.net to get a copy of this message
Help: How to bind a float? i want to bind a float but i cant do it, and i dont know why... :( i have tried $sql_cliente = "insert into clientes(c_n_telemovel, c_nome, c_d_nascimento, c_n_contribuinte, c_saldo,c_pin) values (:c_n_telemovel, :c_nome, :c_d_nascimento, :c_n_contribuinte, :c_saldo, :c_pin)"; ... @OCIBindByName($statement, ':c_saldo', &$csaldo, -1); ... @OCIExecute($statement, OCI_DEFAULT); ... but returns this error : ORA-01722: número inválido (invalid number) the row type of the C_SALDO is number 7 but i have executed this sql sentence : ALTER TABLE "OPTIMAL"."CLIENTES" MODIFY("C_SALDO" FLOAT(7)) after, the row type continues number(7). it does matter? TIA Marco Ferreira ---- Manual Page -- http://www.php.net/manual/en/function.ocibindbyname.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+33507 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+33507&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+33507&report=yes

« previous php.notes (#51120) next »