(Vikram Khatri) When you want SP to return message_text and you also want to handle error code as per your choice, follow this simple example.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help