When you have complex business logic and want to hide the logic implementation then the schema of the stored procedure can be encrypted.
Once the stored procedure is encrypted we need to store it somewhere in the local system and it should be used for the changes.