Try this you need all parameters passed:


SET SERVEROUTPUT ON ;
VARIABLE P1 varchar2(50);
VARIABLE P2 varchar2(50);
VARIABLE P3 VARCHAR2(50);
VARIABLE P4 varchar2(50);
VARIABLE P5 varchar2(50);
VARIABLE P6 varchar2(50);
VARIABLE P7 varchar2(50);
VARIABLE P8 varchar2(50);
VARIABLE P9 varchar2(50);
VARIABLE P10 varchar2(50);
VARIABLE P11 varchar2(50);
VARIABLE P12 varchar2(50);
VARIABLE P13 varchar2(50);
VARIABLE P14 varchar2(50);
VARIABLE P15 varchar2(50);
VARIABLE P16 varchar2(50);
VARIABLE P17 number;
VARIABLE P18 varchar2(50);
VARIABLE P19 number;
VARIABLE P20 varchar2(50);
VARIABLE P21 varchar2(50);
VARIABLE P22 varchar2(50);
VARIABLE P23 varchar2(50);
VARIABLE P24 varchar2(50);
VARIABLE P25 varchar2(50);
VARIABLE P26 varchar2(50);
VARIABLE P27 number;





EXECUTE :P27:=990025;

EXECUTE SP_GET_FUNCOMP_DETAIL(:P1,:P2,:P3,:P4,:P5,:P6,:P7,:P8,:P9,:P10,:P11,:P12,:P13,:P14,:P15,:P16,:P17,:P18,:P19,:P20,:P21,:P22,:P23,:P24,:P25,:P26,:P27);


Replace types with your types and tyhe procedure namae with yours then yopu can print the result.


Gary