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.
The only thing it tells me is that it failed, not why. The procedure name is CCA_SAT and I called it using "EXEC CCA_SAT(?ASSET_NUM)" on the ivr. Any thoughts? Do you know any way to find out why the query failed?
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.
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.