rlm_sqlippool Oracle sql error : ORA-00907: missing right parenthesis

[westwood]

freeradius versions 2.1.8/9/10 + oracle 10.2.0

[sqlippool]     expand: UPDATE radippool   SET nasipaddress = '', pool_key =
0, callingstationid = '',   expiry_time = current_timestamp - INTERVAL '1'
second(1)   WHERE pool_key = '%{NAS-Port}' -> UPDATE radippool   SET
nasipaddress = '', pool_key = 0, callingstationid = '',   expiry_time =
current_timestamp - INTERVAL '1' second(1)   WHERE pool_key = '2'
[sqlippool]     expand: SELECT framedipaddress FROM radippool   WHERE
pool_name = '%{control:Pool-Name}' AND expiry_time < current_timestamp   AND
rownum <= 1   ORDER BY (username <> '%{SQL-User-Name}'),   (callingstationid
<> '%{Calling-Station-Id}'), expiry_time   FOR UPDATE -> SELECT
framedipaddress FROM radippool   WHERE pool_name = 'test_pool' AND
expiry_time < current_timestamp   AND rownum <= 1   ORDER BY (username <>
'test'),   (callingstationid <> ''), expiry_time   FOR UPDATE
rlm_sql_oracle: query failed in sql_select_query: ORA-00907: missing right
parenthesis
rlm_sql_oracle: OCI_SERVER_NORMAL
sqlippool_query1: database query error

  i find the error occured when allocate-find executed  in the file
"sql/oracle/ippool.conf" , but this statement can work well in mysql. How
can i make it works ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101026/02492eb1/attachment.html>