usp_insertuser.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE OR REPLACE PROCEDURE usp_InsertUser
(
   inUserID      CHAR,
   inLoginName   VARCHAR2,
   inPassword    VARCHAR2,
   inFirstName   VARCHAR2,
   inLastName    VARCHAR2,
   inEmail       VARCHAR2,
   inPhone       VARCHAR2,
   inStatus      NUMBER,
   inGroupID     CHAR,
   inRoleID      CHAR,
   inManagerID   CHAR
)
AS
BEGIN
INSERT INTO Users
   (UserID, LoginName, Password, FirstName, LastName, Email,
   Phone, Status, GroupID, RoleID, ManagerID, 	LastUpdateDate)
   VALUES(inUserID, inLoginName, inPassword, inFirstName, inLastName, inEmail,
   inPhone, inStatus, inGroupID, inRoleID, inManagerID, SYSDATE);
END;