Ask Questions and Find Answers

Hi , 
You can either use a Placeholder or QueryPos to include parameter in your Procedure

Ex. 
 CALL somprocedue(? , ? );
 CAL someprocdure([$PARAM1$],[$PARAM2])

Then you can replace the placeholder in your finderimpl using string replace utility or use QueryPos

QueryPos qPos = QueryPos.getInstance(query);
qPos.add(param1);
qPos.add(param2);

Thank you for answer.

But it don't resolve the problem.

I asked about 'OPTIONAL PARAMETERS'. 

This means that once I have to call the procedure with 1 parameter, another time I have to call it with 3 parameters and so on.

My procedure has 11 parameters, only the first beeing mandatory. How to specify that params 2 ... 11 are OPTIONAL ?

So, if you or other anybody has an idea, please post it.

Many thanks,

Alex

HI !

I  renew my request.

No ideas about a solution concerning OPTIONAL PARAMETERS in a SQL procedure ?

Many thanks for any usable information !

Alex