usp_insertproject.sql

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

CREATE OR REPLACE PROCEDURE usp_InsertProject
(
   inProjectID            CHAR,
   inProjectName          VARCHAR2,
   inProjectDescription   CLOB,
   inSequenceNumber       NUMBER 
)
AS
BEGIN
INSERT INTO Projects 
   (ProjectID, ProjectName, ProjectDescription, SequenceNumber, 
      LastUpdateDate)
   VALUES(inProjectID, inProjectName, inProjectDescription, inSequenceNumber, 
      SYSDATE);
END;