Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

Create Stored Procedure

Hello,

I'm attempting to create a stored procedure in order to format data for a custom report. I'm currently using both RazorSQL and AGS Server Studio, but neither one seems to allow me to upload stored procedures to the 'db_cra' database on the UCCX server. I'm logged-in as the 'uccxhruser' user. Does anyone have any instructions for this?

The system version is: 8.5(1)SU2, COP 2.

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Re: Create Stored Procedure

Hi

'Save' will do just that - save to a file. I don't have AGS at the moment - trial expired, and I can't afford it :-) but you will be looking for a button that says 'run' or 'execute' or something similar.

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
5 REPLIES
Bronze

Create Stored Procedure

Hi,

Please refer the below link page number 188 for required permission for stored procedure.

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/programming/guide/uccx85hradm.pdf

Regards,

Gnaneswaran.

Super Bronze

Create Stored Procedure

Hi

That version of UCCX, and those products, with that user should be fine.

What is the error you get exactly?

How are you specifying the 'create function' or 'create procedure' statement?

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

Re: Create Stored Procedure

Hi Aaron,

I'm using the guide at:

http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlt.doc/sqltmst255.htm.

If I log-in to AGS Server Studio, connect to the database and go to: 'Databases > db_cra > Routines (SPL) > Create new routine', a 'New Routine' window appears on the right hand side. Then say, for example, I paste the following in to the 'New Routine' window:

CREATE FUNCTION discount_price (per_cent REAL)

   RETURNING MONEY;

END FUNCTION;

I can check the syntax, but if I click 'Save', AGS Server Studio presumes that I want to save a SQL file to my local hard disk. This is not the case. I want to upload it to the repository!

Super Bronze

Re: Create Stored Procedure

Hi

'Save' will do just that - save to a file. I don't have AGS at the moment - trial expired, and I can't afford it :-) but you will be looking for a button that says 'run' or 'execute' or something similar.

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Community Member

Re: Create Stored Procedure

Thanks Aaron. Creating the function and pressing 'Execute all SQL statement(s)' causes the stored procedure to be uploaded.

508
Views
0
Helpful
5
Replies
CreatePlease to create content