[asterisk-bugs] [JIRA] (ASTERISK-24364) Oracle over odbc realtime broken pjsip

[HZMI8gkCvPpom0tM (JIRA)]

HZMI8gkCvPpom0tM created ASTERISK-24364:
-------------------------------------------

             Summary: Oracle over odbc realtime broken pjsip 
                 Key: ASTERISK-24364
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24364
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: pjproject/pjsip, Resources/res_odbc
    Affects Versions: 12.6.0
            Reporter: HZMI8gkCvPpom0tM


In case of using pjsip with oracle realtime over odbc.
Asterisk try to execute queryes like 

SELECT ID FROM ps_endpoints WHERE id =:0;

Binding variable to :0 is not allowed in oracle (at least for version 10.2.0.5.x) 
Query constantly return ORA-01403: no data found

After it realtime registrations functionality of pjsip completely stop to work.

PS: If to use binding variable names like 
SELECT ID FROM ps_endpoints WHERE id =:var0;
oracle works ok. 
It is possible bug in oracle of course, but i think that change of naming notation for odbc binding variables can solve a lot of compatibility issues with different databases.




--
This message was sent by Atlassian JIRA
(v6.2#6252)