pears.NetDeleteWebReference

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."NetDeleteWebReference"( 
  IN "pWebUserID" CHAR(20),
  IN "pReferenceRequestID" CHAR(20),
  IN "pPersonID" CHAR(20) ) 
RESULT( "pResult" CHAR(250) ) 
BEGIN
  DELETE FROM "ReferenceRequest"
    WHERE "ReferenceRequestID" = "pReferenceRequestID" AND "PersonID" = "pPersonID";
  SELECT '0:~Success'
END /* DOC
2020-07-06 GJ Created
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetDeleteWebReference" IS 
{CREATE PROCEDURE pears."NetDeleteWebReference"( 
    IN pWebUserID CHAR(20),
    IN pReferenceRequestID CHAR(20),
	IN pPersonID CHAR(20)
) 
RESULT( pResult CHAR(250) ) 
BEGIN
 
    DELETE FROM ReferenceRequest
    WHERE ReferenceRequestID = pReferenceRequestID AND PersonID = pPersonID;
 
    SELECT '0:~Success';
END
 
/* DOC
2020-07-06 GJ Created
*/
}