How to solve Orcale 8 Error: ORA-01036: illegal variable name/number??
| From: | Koala | Date: | Tue, 23 Jan 2001 08:57:02 +0000 |
| Subject: | How to solve Orcale 8 Error: ORA-01036: illegal variable name/number?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6081@lists.php.net to get a copy of this message | ||
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....