usp_insertrole.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE OR REPLACE PROCEDURE usp_InsertRole
(
   inRoleID            CHAR,
   inRoleName          VARCHAR2,
   inRoleDescription   CLOB,
   inRanking           NUMBER
)
AS
BEGIN
INSERT INTO Roles
   (RoleID, RoleName, RoleDescription, Ranking, LastUpdateDate)
   VALUES(inRoleID, inRoleName, inRoleDescription, inRanking, SYSDATE);
END;