[cisco-voip] UCCx 10.5 custom stored procedure for reporting

[Bill Talley]

Cool, this includes everything I had been doing as far as I can tell.  Thanks a lot for sharing these details Ed!

Sent from an Apple iOS device with very tiny touchscreen input keys.  Please excude my typtos.

> On Apr 8, 2016, at 7:29 AM, Ed Leatherman <ealeatherman at gmail.com> wrote:
> 
> I haven't touched this in 2 years - here's notes I took when I was playing around with this before in case it will help:
> http://www.evernote.com/l/AAVCJ8P2UbJG5o0yqjxIO6-9p7edydMHCfE/
> 
>> On Fri, Apr 8, 2016 at 8:27 AM, Ed Leatherman <ealeatherman at gmail.com> wrote:
>> Bill,
>>  
>> Does your SP use temporary tables? look at CSCul06940 - I dont know that its resolved in 10.X yet.
>> 
>> Ed
>> 
>> 
>> 
>>> On Thu, Apr 7, 2016 at 6:06 PM, Bill Talley <btalley at gmail.com> wrote:
>>> Hi all,
>>> 
>>> Has anyone imported custom stored procedures into the db_cra for use in CUIC?  I'm having an issue getting a new stored proc loaded using either RazorSQL or AGS Server Studio.  From what I've read, I need to execute the stored proc; however, when I do that I get an error that uccxhruser doesn't have permission to execute the stored proc.  It seems I can't apply permissions to the uccxhruser account on the stored proc until the stored proc is loaded.   Would anyone have any tips on how I can go about getting the stored proc loaded to the database?
>>> 
>>> Hopefully this makes sense to someone ;-)
>>> 
>>> TIA,
>>> Bill
>>> 
>>> _______________________________________________
>>> cisco-voip mailing list
>>> cisco-voip at puck.nether.net
>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>> 
>> 
>> 
>> -- 
>> Ed Leatherman
> 
> 
> 
> -- 
> Ed Leatherman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160408/84af6401/attachment.html>