usp_selectmanagername.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE OR REPLACE PROCEDURE usp_SelectManagerName
(
   inManagerID      IN  CHAR,
   outManagerName   OUT VARCHAR2
)
AS

BEGIN
   SELECT FirstName || ' ' || LastName INTO outManagerName
   FROM Users
   WHERE UserID = inManagerID;
END;