Hi,

> You should use first one SP where u initialise PARAM1 and send after

that to

> your SP as param .

is there any changes if I know which is value of PARAM1, and SP knows
which is PARAM1 I put it into input parameters, just to pass it into
statement?

Thanks ...