userspackagebody.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE OR REPLACE PACKAGE BODY UsersPackage 
AS
   PROCEDURE usp_SelectUsers (results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT UserID, LoginName, FirstName || ' ' || LastName AS UserName,
         Email, Phone, Status
      FROM Users
      ORDER BY UserName;
   END;
END;