Store procedure in oracle, select

Question

Store procedure in oracle, select

Navigation

#1 by (1 votes)

0

I am trying to generate an SP in oracle which returns a select of a column.

Currently

CREATE OR REPLACE PROCEDURE get_usuario(idUser IN USUARIO.ID%TYPE,
  O_EMAIL OUT USUARIO.EMAIL%TYPE)
AS
BEGIN
   SELECT EMAIL
   INTO O_EMAIL
   FROM USUARIO WHERE ID = idUser;
END get_usuario; -- Procedure

The problem is that O_EMAIL will only be loaded with 1 data, I need to return the full select% of email

oracle stored-procedure

asked by Luciano Montañez 09.08.2018 в 00:21

source

1 answer

Validate string format "Latitude, Longitude" Connection failed to localhost MySQL when creating a Database

score 1 · Accepted Answer

To achieve what you want you have to use a cursor. Something like this:

CREATE OR REPLACE PROCEDURE get_usuario(idUser IN USUARIO.ID%TYPE, 
  cursor_ OUT SYS_REFCURSOR)
AS

BEGIN

OPEN cursor_ FOR
      SELECT EMAIL   
      FROM USUARIO WHERE ID = idUser; 
END;