ขอวิธีการเขียน Procedures Update เข้าไป 2 ตารางหน่อยค่ะ

CREATE OR REPLACE PROCEDURE updateTranscript
(
DOC_ID 	  		alumni_documentTranscript.DOC_ID%type,
TYPE_DOCUMENT   alumni_documentTranscript.TYPE_DOCUMENT%type,
LINGO 			alumni_documentTranscript.LINGO%type,
NUMERAL			alumni_documentTranscript.NUMERAL%type,
COMMENTS		alumni_documentTranscript.COMMENTS%type,
COMMENT_TYPE	alumni_document.COMMENT_TYPE%type,
RECEIVE			alumni_document.RECEIVE%type,
RECEIVE_TYPE	alumni_document.RECEIVE_TYPE%type,
PHONE			alumni_document.PHONE%type
)
as 

select alumni_documentTranscript.DOC_ID,alumni_documentTranscript.TYPE_DOCUMENT,alumni_documentTranscript.LINGO,
alumni_documentTranscript.NUMERAL,alumni_documentTranscript.COMMENTS,alumni_document.COMMENT_TYPE,
alumni_document.RECEIVE,alumni_document.RECEIVE_TYPE,alumni_document.PHONE
from  alumni_documentTranscript
join alumni_document on alumni_document.DOC_ID = alumni_documentTranscript.DOC_ID

BEGIN

update alumni_information 
set 


END;
/