Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/26/2023 06:49 AM
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?
Solved! Go to Solution.