userpackagebody.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 13 行

CREATE OR REPLACE PACKAGE BODY UserPackage 
AS
   PROCEDURE usp_SelectUser (inUserID IN CHAR, results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT UserID, LoginName, Password, FirstName, LastName,
         Email, Phone, Status, GroupID, RoleID, ManagerID, LastUpdateDate
      FROM Users
      WHERE UserID = inUserID;
   END;
END;