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'],

When it is execute, it return:  OCIBindByName: ORA-01036: illegal variable

Could anyone tell me what's wrong about this piece of code....

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to