Displaying 1 result from an estimated 1 matches for "p_pbxuser_user_data1".
2006 Jan 20
1
Calling MySQL 5 stored procedures from app_mysql
...new stack
== Spawn extension (macro-local, s, 8) exited non-zero on 'IAX2/100-3' in
macro 'local'
== Spawn extension (users, 123, 1) exited non-zero on 'IAX2/100-3'
-- Hungup 'IAX2/100-3'
So it found 1 peer.
Now trying to call a procedure:
CREATE PROCEDURE p_pbxuser_user_data1(IN _name VARCHAR(20))
BEGIN
SELECT
vm_active
FROM peer,voicemail,pbxuser WHERE peer.name = _name AND
voicemail.mailbox = _name and pbxuser.peer_name = _name;
Result:
-- Executing Macro("IAX2/100-5", "local|100") in new stack
-- Executing MYSQL("IAX2/100...