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

[Ed Leatherman]

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/7f02a3e0/attachment.html>