Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

DB Connector - can Saviynt execute procedures with OUT Parameters?

yogesh
Regular Contributor III
Regular Contributor III

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?

Who Me Too'd this topic