thanx for your quick asnwer , what i mean is this:
---------
IF v_spcExist =1 then
--client spefication section
EXECUTE IMMEDIATE 'spc_getsettlements( p_reltype,
p_debid
p_firstchar ,
p_filter,
rct1 IN OUT globalpkg.rct1 )' ;
-----------
execute immediate cannot call to a stored proc as far as i now, only DML
or can it call a function instead?