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

[Bill Talley]

Closing the loop here, this was my issue. I was able to execute a stored
procedure which wasn't creating a temp table.  Thanks again for sharing Ed.

On Fri, Apr 8, 2016 at 7: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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160408/c34d2282/attachment.html>