SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE PROCEDURE [dbo].[FirstProc]
AS
BEGIN
    BEGIN TRY
       declare @n varchar(200) = 'sys.objects_not_real_table';
       if (OBJECT_ID(@n, 'U')  is null) 
       begin
           set @n += ' is missing';
           raiserror(@n, 16, 1);
           --  or throw:
           --throw 50001, @n, 1;
        end
        SELECT name
        FROM sys.objects_not_real_table;
    END TRY
    BEGIN CATCH
        SELECT 'Error from First Proc: ' + ERROR_MESSAGE();
    END CATCH
END
CREATE PROCEDURE [dbo].[SecondProc]
AS
BEGIN
    BEGIN TRY
        EXEC FirstProc;
        SELECT 'eoj [FirstProc]';
    END TRY
    BEGIN CATCH
        SELECT 'Error from SECOND PROC';
    END CATCH

END
Exec [SecondProc]


(No column name)


Error from First Proc: sys.objects_not_real_table is missing




(No column name)


eoj [FirstProc]