Created by: Justine Joubran on 12-01-2010 03:40:06 PM Dears, I have a script that will be developed on CVP Call Studio. The integration of the script with the backend system of our customer will be done through Stored Procedures. The database is Oracle based. In CVP Call Studio, under the settings tab of the Database Element, I can choose one of the following types: single - multiple - insert - update. I beleive that in order to trigger a stored procedure, I need to choose a type called "store". Is this correct? If not, how can I trigger a stored procedure from the CVP Call Studio? Thanks in advance, Justine.
Subject: Re: New Message from Justine Joubran in Customer Voice Portal (CVP) - CVP - Replied by: Janine Graves on 12-01-2010 05:31:36 PM The database element can not trigger a stored procedure. You will have to write your own custom java for that.
Cisco Developer Community Forums wrote: > Justine Joubran has created a new message in the forum "CVP - All > Versions": > > -------------------------------------------------------------- > Dears, > Â > I have a script that will be developed on CVP Call Studio. The > integration of the script with the backend system of our customer will > be done through Stored Procedures. The database is Oracle based. > Â > In CVP Call Studio, under the settings tab of the Database Element, I > can choose one of the following types: single - multiple - insert - > update. > I beleive that in order to trigger a stored procedure, I need to > choose a type called "store". > Â > Is this correct? If not, how can I trigger a stored procedure from the > CVP Call Studio? > Â > Thanks in advance, > Justine. > Â > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/1890502> > > or simply reply to this email.
Subject: RE: Re: New Message from Justine Joubran in Customer Voice Portal (CVP) - C Replied by: Ranjana Narayan on 13-01-2010 04:02:51 AM Hi Justine, Please refer to http://developer.cisco.com/web/cvp/forums/-/message_boards/message/1517843 for more info an executing StoredProcedure from a CVP application. Hope this helps, Ranjana
Subject: RE: How to trigger a stored procedure using CVP Call Studio? Replied by: Arvand Owji on 27-01-2010 11:36:02 PM Justine, You need to see what your SP is doing. If its returning a single row, then choose single, if it returns multiple, then choose multiple. For a SP that updates or insert to the db, you need to return at least a row at the end of your SP. Something like SELECT 1 FROM TableName. If tried that with SQL Server 2005 in the past and have not had any problems with it.
Subject: RE: How to trigger a stored procedure using CVP Call Studio? Replied by: Janine Graves on 28-01-2010 12:14:16 AM Arvand, Are you claiming that a Stored Procedure that returns one row of data can be invoked by using the Database Element and selecting "single"? Have you tested this? I'd like to pass this information along to my students if it's true.
Subject: RE: How to trigger a stored procedure using CVP Call Studio? Replied by: Arvand Owji on 04-02-2010 03:46:16 PM
Arvand, Are you claiming that a Stored Procedure that returns one row of data can be invoked by using the Database Element and selecting "single"? Have you tested this? I'd like to pass this information along to my students if it's true.
Yes, you can run a stored proc in CVP as long as it returns at least one row of data. I have done it many times. All you need to do is to treat the SP as a select query.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
