Created by: Vinay Kariyappa on 17-03-2010 06:09:09 AM Hi,
Do we have a standard java code for implementing the stored procedure for Oracle database in Callstudio Just checked in the forum ..its bit confusing Please help me in understanding the same Vinay
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 17-03-2010 01:36:05 PM looks like you can just use the Database element to invoke stored procedures. if the procedure returns one row of data, then use the Type: Single. If it returns multiple rows of data, then use Type:Multiple.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > Hi, > > Do we have a standard java code for implementing the stored procedure > for Oracle database in Callstudio > Just checked in the forum ..its bit confusing > Â > Please help me in understanding the same > Â > Vinay > Â > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2046010> > > or simply reply to this email.
Subject: RE: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - G Replied by: Vinay Kariyappa on 17-03-2010 02:52:19 PM Thanks Janine That means i need to put the sp name in the query box , please correct me if i am wrong
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 17-03-2010 03:30:05 PM yes, I believe so.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > Thanks Janine > That means i need to put the sp name in the query box , please correct > me if i am wrong > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2050924> > > or simply reply to this email.
Subject: RE: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - G Replied by: Vinay Kariyappa on 18-03-2010 04:19:12 PM I tried calling stored procedure in the below formats
onlY SP name
SP(in,out,out,out)
exec sp
exec sp(in,out,out,out)
For the methods it says invalid format
Please help me correct this
thanks
Subject: RE: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - G Replied by: Vinay Kariyappa on 18-03-2010 06:30:54 PM its returing single row and 3 coloums please let me know what format i need to use Select sp ? I am confused..
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 18-03-2010 06:25:43 PM Does your stored proc return one row of data or more than one row of data? You have to specify Single if one row of data is returned, Multiple is more than one row is returned.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > I tried calling stored procedure in the below formats > > > onlY SP name > > SP(in,out,out,out) > > exec sp > > exec sp(in,out,out,out) > > > For the methods it says invalid format > > > Please help me correct this > > > thanks > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2052485> > > or simply reply to this email.
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 18-03-2010 07:30:43 PM First, do you know that you can do a single select statement without getting an error? For example 'SELECT 1 as TEST FROM DUAL' (omit quotes) You should get back an element variable named TEST. Please confirm this first.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > its returing single row and 3 coloums > Â > please let me know what format i need to use > Â > Select sp ? > Â > I am confused.. > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2053081> > > or simply reply to this email.
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 19-03-2010 03:05:40 AM Sorry,
I don't have Oracle, so I don't know. I'd try ProcName({Data.Session.var1}, {Data.Session.var2}, {Data.Session.var3}) for example. Perhaps someone who has Oracle can tell you for sure.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > I tried calling stored procedure in the below formats > > > onlY SP name > > SP(in,out,out,out) > > exec sp > > exec sp(in,out,out,out) > > > For the methods it says invalid format > > > Please help me correct this > > > thanks > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2052485> > > or simply reply to this email.
Subject: RE: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - G Replied by: Vinay Kariyappa on 19-03-2010 02:15:15 AM This is working prefectly fine i have used insert update and select statements without any problem I have issue only with stored procedures
Subject: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - Gener Replied by: Janine Graves on 22-03-2010 01:33:40 PM Vinay, Try this from an Oracle client: 'select SP(var1, var2, etc) from dual' . If it works, then that should work from Studio's DB element.
Cisco Developer Community Forums wrote: > Vinay Kariyappa has created a new message in the forum "General > Discussion - All Versions": > > -------------------------------------------------------------- > I tried calling stored procedure in the below formats > > > onlY SP name > > SP(in,out,out,out) > > exec sp > > exec sp(in,out,out,out) > > > For the methods it says invalid format > > > Please help me correct this > > > thanks > -- > To respond to this post, please click the following link: > > <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2052485> > > or simply reply to this email.
Subject: RE: Re: New Message from Vinay Kariyappa in Customer Voice Portal (CVP) - G Replied by: Vinay Kariyappa on 23-03-2010 05:10:53 PM Thanks Janine I got that one working via java class but will try the suggested method
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:
