Thank very mcuh for answering adignan.

I?m looking a solution for IP IVR of IPCC Express, this is for an enterprise to give extra credit by given information of their credit card.

The first solution was using Store Procedure but I found out that IPCC Express does not support Store Procedure now the customer asked my if we can do it by using web services.

Regards.

Walter

You can do stored procedures.

Here are the steps

1. Create a table in the database that has the exact same columns in it in the same order that the sproc returns. This is a dummy table that is only used for the CRS to capture schema. No data is stored in it but it must match the sproc exactly. Also make sure that your sproc is asigning column names when it returns. You and use alias for that.

2. Use a DB read step but instead of doing a SELECT do and EXEC. Just make sure that your $vars have spaces before AND after them. For example

EXEC sprocname $var1, $var2 will fail but

EXEC sprocname $var1 , $var2 will work fine

The idiot who wrote the parser code for the DB read step had no business writing a parser and it is full of bugs.

I have used this technique many times and it works much better than the standard Select statements

You can use the DB Get as normal after calling the stored proc so long as your column names match exactly.

What is the last sentance under 1.? It appears to be incomplete...

You and use alias for that.....?

Pleade advise, Thankyou!!

How do you pass the procedures Input values?

Do these need to be in the dummy table as well?

If this doesn't work, can stored Procs be called from Java expressions in IPCC

My procs are Oracle PL/SQL, we don't have our IPCC yet otherwise I would try this

thanks in advance

Hey shannon,

I would like to thank you for your very detailed explanation regarding StoredProc in CRS. I was able to finish my script successfully.

On another hand, I would apreciate if you could write a same detailed post regarding Web Services vs CRS. (How to)

Thanks in advance

Steven

Hi Steven, I have been working calling web services from CRS too. For the solution, I will use web enabled client script which will make http post or get request from web services. Then I will get results from returned xml document by using XML Path. I think this will work. To do this I suggest you should check out web-enabled client script section in this document (http://www.cisco.com/application/pdf/en/us/guest/products/ps8219/c1667/ccmigration_09186a008084d928.pdf).

The document does not say how you can call web service by making http post or get reguest. You can see a sample .net web service call from http.

http://localhost/WebSite1/Service.asmx/MySite?var1=mickey&var2=knox

Regards,

Selim Budakoğlu