I had an Oracle procedure I called passing 3 parameters;

sSQL = ""
sSQL = sSQL & " call"
sSQL = sSQL & " package.p_name('"
sSQL = sSQL & vInput_1 & "'"
sSQL = sSQL & ",null,'"
sSQL = sSQL & vInput_3 & "')"

The code worked with no issues.

then the DBA added 2 returned Output variables;

PROCEDURE p_name(i_input_1 IN column%TYPE,
i_input_2 IN column%TYPE,
i_input_3 IN column%TYPE,
o_output_1 OUT INTEGER,
o_output_2 OUT VARCHAR2) IS
etc...

Can anyone tell me how I deal with the procedure call and the parameters that are trying to be passed back in vb 6.0 code?

Thanks,