CREATE OR REPLACE PROCEDURE prc_InsertCategory ( 
	p_Category_Name IN VARCHAR2, 
	p_Category_Guid IN VARCHAR2, 
	p_Category_Id OUT INT ) 
IS 
BEGIN 
	SELECT S_CATEGORIES.nextval 
	INTO p_Category_Id 
	FROM DUAL; 
	
	INSERT INTO Categories ( 
		Category_Id,	
		Category_Name, 
		Category_Guid ) 
	VALUES (	
		p_Category_Id, 
		p_Category_Name, 
		p_Category_Guid ); 
END;