Here is the code: $arr_var = Array(); $arr_var[] = Array("KEY"=>'rec_id', "VALUE"=>'000000', "LENGTH"=>-1);\ ...... $stmt = OCIParse('DECLARE rec_id NUMBER(20); SELECT recNum INTO rec_id FROM table WHERE recNum= 2 '); ...... $num_rows = count($arr_var); for ($i=0; $i<$num_rows; $i++) { if (is_array($arr_var[$i])) { OCIBindByName($stmt, $arr_var[$i]['KEY'], $arr_var[$i]['VALUE'], $arr_var[$i]['LENGTH']); } } .... When it is execute, it return: OCIBindByName: ORA-01036: illegal variable name/number Could anyone tell me what's wrong about this piece of code.... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]