projectpackagebody.sql

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

CREATE OR REPLACE PACKAGE BODY ProjectPackage
AS
   PROCEDURE usp_SelectProject (inProjectID IN CHAR, 
      results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
   OPEN results_cursor FOR
   SELECT ProjectID, ProjectName, ProjectDescription, SequenceNumber, 
      LastUpdateDate
   FROM Projects
   WHERE ProjectID = inProjectID;
   END;
END;