Re: How to solve Orcale 8 Error: ORA-01036: illegal variable name/number??

On Tue, Jan 23, 2001 at 04:57:02PM +0800, Koala wrote: > 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 DECLARE is implemented in sqlplus and not part of oracle's SQL - you should be find by just saying: $stmt = OCIParse('SELECT recNum INTO rec_id FROM table WHERE recNum= 2 '); ocibindbyname($stmt,"REC_ID",$rec_id,128); tc