Using bind variable in Remove access in Database connector

[prachi]

Hi,

I am trying to call the stored procedure for remove access in the database connector. However my stored procedure returns a result which is stored in the bind variable. I am using Oracle database , and access is revoked when i try executing the statement in db : 

CALL apps.Saviynt_remove_user_resp('3955','Journal Entry',:status)

where :status is the bind variable passed as input parameter.

I am trying to pass the same statement in my remove access JSON as :

{
"Responsibility": ["CALL apps.Saviynt_remove_user_resp('${accountName}','${task.entitlement_valueKey.entitlement_value}',:status)"]
}

After running the WSRETRY i do not see any error in logs or any chtange in task status or update date/time

Can you help me fix this issue, I am assuming this could be due to passing the bind variable, not sure of saviynt supports this format.

Thanks in advance

[sahajranajee]

Hello,

Since you will be using the JDBC driver for oracle to integrate with your target, the binding should be supported as long as your jdbc driver supports it. 

Which app version are you trying this on. Can you try executing just this task and share the logs.

[prachi]

Hi,

Thankyou for the response.

The issue is resolved now.

[sahajranajee]

Hi @prachi 

That is great news! Could you please add the solution here on the post for the benefit of the community?

[prachi · Accepted solution]

Hi,

In security system i had turned automated provisioning off so the task time was not at all changing.. when i turned on the same JSON that i had when we were in call, it worked