asked on
PROCEDURE VerifyCounterparty(
v_EmailAddress IN VARCHAR,
v_Password IN VARCHAR2,
v_Count OUT NUMBER,
v_AccountLocked OUT NUMBER,
v_TradesCompanyId OUT NUMBER,
v_FirstName OUT VARCHAR2)
IS
BEGIN
SELECT COUNT(firstname) firstname,
ACCOUNTLOCKED,
TRADESCOMPANYID,
FIRSTNAME
INTO v_Count,
v_AccountLocked,
v_TradesCompanyId,
v_FirstName
FROM T_USER
WHERE EMAILADDRESS = v_EmailAddress
AND PASSWORD = v_Password GROUP BY ACCOUNTLOCKED, TRADESCOMPANYID, FIRSTNAME;
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_Count := 0;
v_AccountLocked := 0;
v_TradesCompanyId := 0;
END VerifyCounterparty;