Create Stored Procedure

[nowcommsupport]

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.

[gnanem]

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.

[Aaron Harrison]

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

[nowcommsupport]

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!

[Aaron Harrison · Accepted solution]

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

[nowcommsupport]

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