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

[Alan DeKok]

westwood wrote:
> freeradius versions 2.1.8/9/10 + oracle 10.2.0
...
> rlm_sql_oracle: query failed in sql_select_query: ORA-00907: missing
> right parenthesis

  That's an Oracle error.  The query is malformed.

>   i find the error occured when allocate-find executed  in the file
> "sql/oracle/ippool.conf" , but this statement can work well in mysql.

  Uh... you're using MySQL syntax for an Oracle server?

> How can i make it works ?

  Use Oracle SQL syntax.

  Alan DeKok.