I have a question I am using stored procedures with oracle and take them to a web page in asp the question is that I have this stored procedure from which I get the login and password of the database.
But I also want to bring a description that exists within the same query my procedure is defined as I do to capture the description and take it to a textbox
PROCEDURE VALIDARLOGIN (pLOGIN IN VARCHAR2,
pPASSWORD IN VARCHAR2,
p_cursor OUT SYS_REFCURSOR)
IS
BEGIN
OPEN p_cursor FOR
SELECT USULOGIN, USUPASSW, DESCRIPCION
FROM SEGMUSUARIO u, DEPENDENCIA d
WHERE u.CODIGO = d.CODIGO
AND (USULOGIN = pLOGIN)
AND (USUPASSW = pPASSWORD);
END VALIDARLOGIN;