PL/SQL (MOSC)

MOSC Banner

function with parameter passing giving error

edited Feb 16, 2015 10:04AM in PL/SQL (MOSC) 17 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center