[asterisk-users] About IVR and Oracle

[Tim Panton]

On 23 Aug 2006, at 23:07, Javier Lara Sanchez wrote:

> Dear All,
>
>
>
> I need to buid an IVR that could make a request to a data base  
> (oracle) in a remote host.
>
>
>
>  The idea is that an user dial a extension with 2 options and one  
> of them ask for a data (in the case a date). This data is the field  
> that the data base needs to find the information that the user are  
> looking for..
>
>
>
> Somebody know if this is posible or have any idea where can I find  
> information about this?

We have done this by using the (excellent) asterisk-java api on  
sourceforge to create a
FAstAGI server on the database box. (http://asterisk-java.org/latest/)

Asterisk makes a FastAGI call to this server, the server looks up the  
query by JDBC, sets
the result in a channel variable and returns control to asterisk's  
dialplan.
The dialplan then does the 'right' thing with the call.

This means we keep the connection duration to the FAstAgi server to a  
minimum.

Tim.
>
>
> Thank
>
> Regard
>
> Javier
>
>
>
>
>
>
>
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Tim Panton

www.mexuar.com