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