« Back to CVP - All Versions

How to trigger a stored procedure using CVP Call Studio?

Combination View Flat View Tree View
Threads [ Previous | Next ]
How to trigger a stored procedure using CVP Call Studio?
Answer
1/12/10 9:40 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.
 
Flag

Re: New Message from Justine Joubran in Customer Voice Portal (CVP) - CVP -
Answer
1/12/10 11:31 PM as a reply to Justine Joubran.
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.
Flag

RE: Re: New Message from Justine Joubran in Customer Voice Portal (CVP) - C
database stored procedure
Answer
1/13/10 10:03 AM as a reply to Janine Graves.
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
Flag

RE: How to trigger a stored procedure using CVP Call Studio?
Answer
1/28/10 5:36 AM as a reply to Justine Joubran.
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.
Flag

RE: How to trigger a stored procedure using CVP Call Studio?
Answer
1/28/10 6:14 AM as a reply to Arvand Owji.
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.
 
 
 
 
Flag

RE: How to trigger a stored procedure using CVP Call Studio?
Answer
2/4/10 9:46 PM as a reply to Janine Graves.
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.
Flag