Nested Stored ProcedureI had One Stored Procedure Main and a Nested Stored Procedure say Main 1 i am calling the Nested Stored procedure in Main Procedure in Main1 Procedure i have some Custom messages that should be displayed in Front end and it will rollback in the Next Statement and in the Catch Exception i am having another Rollback . But i am getting error that No matching Begin Transaction for the Rollback transaction so for the exception i had put the flag or @@transcount so the exception gone but the Custom message which is output parameter i am unable to get in the front end . so any Suggestions
Main stored Procedure
message = "some message"
if @flagrolled =0
but i want to retrieve the message output parameter not only one message i want to retrieve more than one messages are there