I needed to create my own question using SQL Oracle and so I wrote this out

049: SELECT a.animal_name, a.animal_age, CASE a.animal_sex WHEN 'F' THEN 'Female'

050: WHEN 'M' THEN 'Male' END,

051: b.breed_type, b.breed_name, v.vol_first || ' ' || v.vol_last

052: FROM animal a JOIN breed b ON a.breed_id = b.breed_id JOIN volunteer ON a.vol_id = v.vol_id;

However, I keep getting this error: ORA-06553: PLS-306: wrong number or types of arguments in call to 'V' 06553. 00000 - "PLS-%s: %s" *Cause: *Action: Error at Line: 51 Column: 29

What am I doing wrong?