DB Connector - can Saviynt execute procedures with OUT Parameters?

[yogesh]

Does Saviynt DB connector support executing procedures which have OUT parameters?

Example of procedures with OUT parameter:

SQL Server:

Exec [dbo].[AddUser] @UserID='test123', @EmployeeID='test123', @FirstName='test123', @LastName='123', @RequestID='12345', @Error=@Error output, @Result=@Result output;

Oracle:

exec customer_package.create_account (
  p_profile          => 5,
  p_username         => 'testuser1',
  p_password         => 'Pass1234',
  p_error            => p_output);

If supported can you please provide samples of connection JSONs for oracle and sql server?

[DixshantValecha]

Hi @yogesh ,

Thanks for reaching out to saviynt forums,We are checking on this and we will provide you an update shortly on this.

[DixshantValecha]

Hi @yogesh,

Kindly furnish your business use case, elucidating the necessity for OUT parameter procedures .

[yogesh]

The issue is that we are trying to use procedures which are already present in system and fulfill our use cases but they have OUT variables.

If there is a way to even ignore them while calling from Saviynt then we can leverage the same without having to rework on developing new procedures for same functionality but without OUT variables just for Saviynt. Which would ultimately mean addtional effort and costs.

[DixshantValecha · Accepted solution]

Hi @yogesh,

We sincerely regret to inform that you need to establish new procedures for your request. Regrettably, the aforementioned request cannot be accommodated within the framework of Saviynt's current capabilities.

[yogesh]

Thanks for the confirmation