[Home]

Summary:ASTERISK-22240: Asterisk 1.8 func_odbc oracle stored procedure is not working
Reporter:Arnaldo R. Gonzalez Jimenez (Chaca_man)Labels:
Date Opened:2013-08-01 19:22:07Date Closed:2013-08-01 21:15:14
Priority:MajorRegression?
Status:Closed/CompleteComponents:Functions/func_odbc
Versions:1.8.21.0 Frequency of
Occurrence
Constant
Related
Issues:
Environment:LinuxAttachments:
Description:first test func_odbc:

[vpin]
dsn=hd_test

readsql= DECLARE
readsql+= variable1 varchar2(100);
readsql+= variable2 varchar2(100);
readsql+= variable3 varchar2(100);
readsql+= variable4 varchar2(100);
readsql+= BEGIN HD.IVR_AUTENTIC(4,4020003802,0883,variable1,variable2,variable3,variable4);
readsql+= END;
readsql+= /



Asterisk Message File:

WARNING[9747] func_odbc.c: SQL Exec Direct failed (-1)![DECLARE 'variable1 varchar2(100) 'variable2 varchar2(100) 'variable3 varchar2(100) 'vari      able4 varchar2(100) 'BEGIN HD_BDI.IVR_AUTENTIC(4,4020003802,0883,variable1,variable2,variable3,variable4) 'END /]
Comments:By: Matt Jordan (mjordan) 2013-08-01 21:15:07.142-0500

Thanks for your comments. This does not appear to be a bug report and we are closing it. We appreciate the difficulties you are facing, but it would make more sense to raise your question in the support tracker, http://www.asterisk.org/support.