Stored Procedure Problem

[Debasish Dutta Roy]

Dear all
The documentation of SP is so bad it really creates loads of downtime.

Can anyone give me a detailed example of using Stored Procedure. My requirements...

1. The SP looks like

{?=call test_request.mySP(?,?)}

where 1 = Registered out parameter type INT, 2=In Parameter type INT, 3=Out Parameter type VARCHAR

I have an object that contains 3 member variables. So in the xml my SP looks like

{#output1#=call test_request.mySP(#requestId#, #output2#)}

Cannot get to work. Trying out several combinations stupidly.

Has anyone done like this? Urgent...