Hi

I need to make some daily update on SQL server database from oracle database
For this, I need to execute procedure on Oracle database and following answer of that procedure update or not SQL server database

In my DTS , i have configured microsoft OLE DB provider for Oracle.
Oracle stored procedure is : PR_oracle (arg1 in varchar2, return_code out varchar2

I wrote in lookups/query designer following
begin pr_oracle(?,?); end

and in ActiveX Scrip
dim re
DTSLookups("pr_oracle").Execute DTSSource("arg1"), re

but it does not work.
Is it possible to do this kind of transformation through DTS
Thanks for your help
Flo