rolepackagebody.sql

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

CREATE OR REPLACE PACKAGE BODY RolePackage 
AS
   PROCEDURE usp_SelectRole (inRoleID IN CHAR, results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT RoleID, RoleName, RoleDescription, Ranking, LastUpdateDate
      FROM ROLES
      WHERE RoleID = inRoleID;
   END;
END;