[asterisk-dev] ADDON: Realtime extension

[North Antara]

René Enskat [Teamware GmbH] wrote:
>
>  
> i have realtime running over oracle database when i have some _ 
> extensions in the database the asterisk won't accept them.
> Here i tried to call number 47.
> the extension for this one in the db is: _4[6-9]
> so the second select should found something with sqlnavigator i find 
> the row but asterisk seems to stop continuing after that i get th 
> emessage invalid extension.
>  
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Retrieve SQL: SELECT * FROM ast_extension WHERE exten = '47'  AND 
> context = '10001'  AND priority = '1'
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Reconnected successfully.
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Retrieve SQL: SELECT * FROM ast_extension WHERE exten LIKE '\_%' 
> ESCAPE '\' AND context = '10001'  AND priority = '1'  ORDER BY exten
> May 10 11:58:48 DEBUG[18202] res_config_oracle.c: Oracle RealTime: 
> Reconnected successfully.
I noticed something similar with mssql.  I believe I had to change the 
\\_% to _% in the code.