Does Saviynt DB connector support executing procedures which have OUT parameters?
Example of procedures with OUT parameter:
Exec [dbo].[AddUser] @UserID='test123', @EmployeeID='test123', @FirstName='test123', @LastName='123', @RequestID='12345', @Error=@Error output, @Result=@Result output;
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?
Solved! Go to Solution.
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.