Hi Aruna,

I havent read any of the replies. Just read your prob and giving the possible solution.

Try running the following piece of code in SQL*PLUS :
(Set ServerOutPut ON)

DECLARE
OptValue NUMBER ;
BEGIN
Exec insertblkheader(10,10,10,10, OptValue);
DBMS_OUTPUT.PUT_LINE('Value Returned Is : '||OptValue) ;
END ;

This should work. Your procedure has 4 input parameters and 1 output parameter. So total 5 parameters. You need to specify the 5th output parameter, the parameter in which your output value will be stored.


Good Luck,

Pinakin.