i ve a table in a oracle database. i want to create a stored procedure to retrieve multiple rows depending upon the input info..assume xxx and yyy are in table
Code:
create or replace procedure proc_name(data_in IN varchar, data_out OUT) as BEGIN select xxx INTO data_out from table_name where yyy=data_in;end;
wat if when i ve multiple data_in that matches yyy...how to retrieve all of them and corresponding rows..
pl help.
thanks in advance.
retrieving multiple rows from table
