How to solve PL/Sql Function compilation error

Question

I have two table .one from server and another from host.I have to union them and count total donor by gender.I tried to run this function.But It shows error.How can I solve it?

**create or replace function count_donor_by_gender(g in Donor.gender%TYPE)
    return number
    is
    
    g_donor number:=0;
    
begin

    FOR R IN (select *  from Donor@site_link union Donor) LOOP
        if(R.gender=g) then
            g_donor:=g_donor+1;
        end if;
    END LOOP;
    
    return g_donor;

end count_donor_by_gender;
/**

Compilation Error

Missing Select Keyword and sql statement ignored...I have added a pic — Lb4340
– Lb4340, Commented Mar 19, 2021 at 7:50
I have two table .one from server and another from host.I have to union them and count total donor by gender — Lb4340
– Lb4340, Commented Mar 19, 2021 at 7:52

ekochergin · Accepted Answer · 2021-03-19 07:55:26Z

1

The error is here

select *  from Donor@site_link union Donor

The "union" statement append results of 2 SELECT statements into one, so you need to

select *  from Donor@site_link union select * from Donor

Please be aware that "UNION" causes database to remove duplicates which may degrade the performance. If removing duplicates was not intented, use "UNION ALL" instead

answered Mar 19, 2021 at 7:55

ekochergin

4,1592 gold badges14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to solve PL/Sql Function compilation error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related