Hi Team,
We are using a stored procedure to perform account/access removal using a DB connection.
We have a specific case that the stored procedure should not delete the account or access from DB in case the account is present in a specific table. For this case, the App team is providing an output response that will mention the reason why the account can not be deleted through the stored procedure.
Is it possible to display that output message from Stored Procedure in Saviynt anywhere?
If not, what other approach could we take here?
Queries run by stored procedure are below -
/*CHECK IF THE APPLICATION USER IS ASSOCIATED WITH ANY CRO PERSON RECORD*/
1. SELECT COUNT(*) FROM CRO_XXXX p WHERE p.USER_TKEY = '?';
/*IF COUNT(*) >0 CAN'T DELETE THIS USER WITH ERROR MESSAGE- ERROR:There is a CRO XX PERSON linked to this Application User.*/
/*IF COUNT(*) =0 PROCEED WITH DELETION*/
2. DELETE FROM USER_SESSIONS A WHERE A.USER_TKEY = '?';
__________________________________________________________________________
Below is the stored proc -
DECLARE
result VARCHAR2(200);
BEGIN
SA_SAVIYNT_USER.SAVIYNT_USER_DELETION(‘<username>', result);
DBMS_OUTPUT.PUT_LINE(result);
END;
