multiple query in storeprocedure

See more:

C#

ASP.NET

ALTER PROCEDURE dbo.update_data
	@user_id numeric(18,0),
	@name1 varchar(50),
	@address varchar(50),
	@mob varchar(50),
	@city varchar(50),
	@emailid varchar(50),
	@username varchar(50),
	@password varchar(50),
	@log_id numeric(18,0)
AS


BEGIN    
  Begin Transaction


	begin


	UPDATE    [user.]
	SET name1 = @name1,
		address = @address,
	    mob = @mob,
	    city = @city,
	    emailid = @emailid
	    
	    
		WHERE (user_id = @user_id)
	
SELECT     log_id
FROM         [user.]
WHERE     (user_id = @user_id)
	end


	begin
	UPDATE    login
	SET              username = @username, password = @password
	WHERE     (log_id = @log_id)
	end
	Commit  transaction
end

i have two table.1)profile :
name
address
city
mob
emailid
log_id

2)login:
log_id
username
password

i have to update data in profile and then select log_id from that updated data.
using this log_id i have to update login table.
for this i have write store procedure as given.but error comming like :storeprocedure expect parameter @log_id

what is problem in my code?