how to get the value of a stored procedure

0

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;
    
asked by WilliamCuervo 09.05.2018 в 18:45
source

0 answers