calling Oracle stored procedure within a dts package

[anupamanimak]

I need to call an oracle stored procedure from a DTS package. I used Execute SQL task. I need to pass input parameters to the procedure and I need to get back some computed values. I thought I could do it by setting up the global parameters and using the "Parameters" button on the Execute SQL task. I have my procedure call as :

begin
pkg_test.pr_test(inparam1 => ?, outparam2 => ?) ;
end;

But when I click on the "Parameters" button, I get a message
"SQL statement does not contain any parameters"

what am I doing wrong?

Thanks,
Anupama

 

[newtechy]

HAve you figured out this problem yet??