function with parameter passing giving error
how i can resolve the below error.. it is giving error while creating function.
CREATE or replace function software_deletion
(
p_spsn IN VARCHAR2,
p_spon IN VARCHAR2,
p_version IN VARCHAR2
)
RETURN NUMBER
IS
p_result NUMBER;
cursor c1 select distinct sd.swid, sdd.swdid, sp.token from software_data sd, software_data_detail sdd, software_platforms sp where sd.swid = sdd.swid and sp.swdid = sdd.swdid and sd.spsn = p_spsn and sd.spon = p_spon and sdd.version = p_version and sdd.package_type = 'PP';
v_swid c1%rowtype;
v_swdid c1%rowtype;
v_token c1%rowtype;