I have been trying to execute a stored procedure from the IVR but I keep getting a FAIL status no matter how I write the code on the IVR action node. I wrote my code following the instructions from another post here in the forum but it still returns only FAIL. I am using CCA 8.1.3 FP5 with an Oracle DB 10g.
-The IVR code:
EXEC CCA_SAT ?ASSET_NUM, $SR_NUM
create or replace
PROCEDURE CCA_SAT (ASSET_NUM in number, SR_NUM out number) IS
SR_NUM := ASSET_NUM * 2;
Anyone has any idea of what might be wrong? Connection with the DB is fine since I can run simple selects and play the results. Any help is appreciated.
Thanks in advance,
The directions in the thread below: CCA Stored Procedure
Will work... If you get any errors, pls set your call centers to trace level 5.
Then run the proc from IVR.
Post the log here if you need help reading the error.
Search for the Proc name in the log.
I only have the standard configurations for the database:
Alias, Name and Description : DEVSIEBE (I have a JDBC connection in webelogic with this name)
Login : SIEBEL (Standard login for a Siebel DB)
The password is correct since I can run simple queries on the db, like finding users.
Is there any other configuration I am missing here? These seem quite straightforward so I do not see any problem with them.
Thank you for the help and happy new year.
Have you tried;
EXEC CCA_SAT ?ASSET_NUM, ?SR_NUM
I had the same issue (MS Database) and CCA wouldn't let me use the $ sign, I collected information using variables such as $SR_NUM, but sent them to sproc as ?SR_NUM and that worked just fine.
Rschepis and Amartinez,
I did try both ways, but none worked. Since I have a schedule to follow I ended up replacing my stored procedure with a function and an insert. It is working just fine, it seems that the problem happens only with the spoc.
Thank you very much for the help.