note 33507 rejected from function.ocibindbyname by torben

From: Date: Sat, 28 Jun 2003 02:29:21 +0000
Subject: note 33507 rejected from function.ocibindbyname by torben
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-51123@lists.php.net to get a copy of this message
Note Submitter: macf@student.dei.uc.pt ---- 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

« previous php.notes (#51123) next »