Return Multiple Value in Oracle Function

See more:

SQL

Oracle

Dear All,

i am not able to return multiple value.

i wan to return tmpVar,tmpVar1,tmpVar2,tmpVar3 from my below mention function

can anybody help me out.

My code is as follows

CREATE OR REPLACE FUNCTION ESUPPORT.TRAINING_SCORE (train_id NUMBER) RETURN number IS
tmpVar NUMBER ;
tmpVar1 NUMBER ;
tmpVar2 NUMBER ;
tmpVar3 NUMBER ;

v_no_of_participant number :=0;
v_sum_of_responsce_prog_cont number :=0;
v_sum_of_responsce_prog_facu number :=0;
v_sum_of_responsce_prog_logi number :=0;
v_sum_of_responce_prog_lear number :=0;

BEGIN
select COUNT(*) into v_no_of_participant FROM ESUPPORTV_FB_TRAINING_FEEDBACK WHERE FB_TRAINING_ID = train_id;
select sum(A1)+sum(B1)+sum(C1)+sum(D1) into v_sum_of_responsce_prog_cont FROM ESUPPORTV_FB_TRAINING_FEEDBACK WHERE FB_TRAINING_ID = train_id;
select sum(A2)+sum(B2)+sum(C2)+sum(D2) into v_sum_of_responsce_prog_facu FROM ESUPPORTV_FB_TRAINING_FEEDBACK WHERE FB_TRAINING_ID = train_id;
select sum(A1)+sum(B1)+sum(C1)+sum(D1) into v_sum_of_responsce_prog_logi FROM ESUPPORTV_FB_TRAINING_FEEDBACK WHERE FB_TRAINING_ID = train_id;
select sum(A1)+sum(B1)+sum(C1)+sum(D1) into v_sum_of_responce_prog_lear FROM ESUPPORTV_FB_TRAINING_FEEDBACK WHERE FB_TRAINING_ID = train_id;
tmpVar := v_sum_of_responsce_prog_cont/(4*v_no_of_participant);
tmpVar1 := v_sum_of_responsce_prog_facu/(4*v_no_of_participant);
tmpVar2 := v_sum_of_responsce_prog_logi/(4*v_no_of_participant);
tmpVar3 := v_sum_of_responce_prog_lear/(4*v_no_of_participant);

RETURN tmpVar;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END TRAINING_SCORE;

Thanking you