pears.NetClientContractVacancyDetails

CREATE PROCEDURE "pears"."NetClientContractVacancyDetails"( IN "pWebUserID" CHAR(20),IN "pvacancyid" CHAR(20) ) 
RESULT( "Title" CHAR(100),"Description" long VARCHAR ) 
BEGIN
  SELECT "position","othernotes" FROM "vacancy" WHERE "vacancyid" = "pvacancyid"
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientContractVacancyDetails" IS 
{CREATE PROCEDURE pears."NetClientContractVacancyDetails"( IN "pWebUserID" CHAR(20),IN "pvacancyid" CHAR(20) ) 
RESULT( "Title" CHAR(100),"Description" long VARCHAR ) 
BEGIN
  SELECT "position","othernotes" FROM "vacancy" WHERE "vacancyid" = "pvacancyid"
END
}