Creating a ODBC variable

Hi, I creat the Table (DB2 - sql statment): create table tb_proj (codproj char(12) not null,result long varchar, finali long varchar,primary key (codproj)) in tp_dbsp1 Insert in DB2 (ODBC) in Php: ================================================ $query = "insert into tb_proj values('$cod','$res','$fin')"; if (!($result = odbc_Exec($conn, $query))){ print("Mensagem:".odbc_errormsg()); ================================================ I allways have the same message: Invalid SQL Command... Solution : creat a host variable in PHP. Solution - Oracle: ================================================ $sql = "INSERT INTO tb_proj (codproj,result,finali) VALUES ('$cod',:resu,:fina);"; $stmt = OCIParse($conn, $sql); OCIBindByName($stmt,":resu",$res,100); OCIBindByName($stmt,":fina",$fin,100); OCIExecute($stmt, OCI_DEFAULT); ================================================ Solution - ODBC ???????? can anybody help me??? thanks Liris