T-SQL problems - stored procedure calling stored procedures

ALTER PROCEDURE svimwges_miv.test_UploadImage
 @ImageData binary,
 @ImageWidth int,
 @ImageHeight int,
 @PreviewImageData binary,
 @PreviewImageWidth int,
 @PreviewImageHeight int,
 @ImageFormat nvarchar(255),
 @ImageId uniqueidentifier OUTPUT
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

 -- Insert statements for procedure here 
 BEGIN 
 DECLARE @MainImageId uniqueidentifier
 EXEC @MainImageId = svimwges_miv.test_UploadMedia 0,@ImageData,@ImageFormat
 EXEC svimwges_miv.test_AddMediasAttributes @MainImageId,'Width',@PreviewImageWidth
 EXEC svimwges_miv.test_AddMediasAttributes @MainImageId,'Height',@PreviewImageHeight
 DECLARE @PreviewImageId uniqueidentifier
 EXEC @PreviewImageId = svimwges_miv.test_UploadMedia 0,@PreviewImageData,@ImageFormat
 EXEC svimwges_miv.test_AddMediasAttributes @PreviewImageId,'Width',@PreviewImageWidth
 EXEC svimwges_miv.test_AddMediasAttributes @PreviewImageId,'Height',@PreviewImageHeight
 EXEC svimwges_miv.test_AddMediasAttributes @MainImageId,'PreviewImageId',@PreviewImageId
 EXEC @ImageId = @MainImageId
 END 
END

Select allOpen in new window

ALTER PROCEDURE svimwges_miv.test_UploadMedia
 @MediaType tinyint,
 @MediaData binary,
 @MediaFormat nchar(4),
 @MediaId uniqueidentifier OUTPUT
AS
DECLARE @err_message nvarchar(255)
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here 
 BEGIN 
  SET @MediaId = NEWID()
	IF @MediaType < 0 OR @MediaType > 3 -- 0 = image, 1 = video, 2 = audio
    BEGIN 
		SET @err_message = @MediaType + ' is not a valid media type!'
		RAISERROR (@err_message, 11,1)
    END

  INSERT INTO miv_Medias(MediaId, MediaType, MediaData, MediaFormat, CreateDate) 
  VALUES(@MediaId, @MediaType, @MediaData, @MediaFormat, GETUTCDATE())
 END 
END

Select allOpen in new window

ALTER PROCEDURE svimwges_miv.test_AddMediasAttributes
 @MediaId uniqueidentifier,
 @AttributeName nvarchar(MAX),
 @AttributeValue nvarchar(MAX)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here 
 BEGIN

 IF EXISTS (SELECT 1 FROM miv_MediasAttributes WHERE MediaId = @MediaId AND AttributeName = @AttributeName)
	BEGIN
		UPDATE miv_MediasAttributes SET AttributeName = @AttributeName, AttributeValue = @AttributeValue WHERE MediaId = @MediaId AND AttributeName = @AttributeName
	END
 ELSE
	INSERT INTO miv_MediasAttributes(MediaId, AttributeName, AttributeValue, CreateDate) 
  VALUES(@MediaId, @AttributeName, @AttributeValue, GETUTCDATE())
 END 
END

Select allOpen in new window