Hello Andy: The simple answer is yes. Think of stored procedures as small mini/micro sql applications. From Asterisk you can execute a shell script, perl script and even if necessary a java app... so technically there is really nothing stopping you from calling sql stored procedures from Asterisk.
I suspect you are going to connect to the external SQL which is Microsoft SQL. I still don't see this as a problem because you can technically write scripts to parse data from an external source/server. In the SQL world it is done quite often, connecting & interconnecting to different SQL servers... that is mySQL to MS-SQL to Oracle to DB2 and so on. Hope this helps. Cheers! Reza. ----- Original Message ----- From: Andy Jaikissoon To: TAUG Sent: Tuesday, October 10, 2006 4:18 PM Subject: [on-asterisk] Asterisk and SQL Stored Procedures Hi everyone, Anyone out there know if this could work? I've got SQL down pat but I'm being forced to switch to stored procedure to read certain value from an external SQL database (not mySQL). Can Stored Procedures be invoked from Asterisk? Andy Jaikissoon
