Calling an Oracle Function Using MS Oracle Provider and VS 2005

[Hoffman, Ira]

All,

I am able to call an Oracle function using The OracleClient Objects, but not
using a data map. Here is the Oracle Client translation:

                OracleConnection rempOc = new OracleConnection();
                rempOc.ConnectionString = "User Id=xxx;Password=xxxSS;Data
Source=xxx;";
                rempOc.Open();
                OracleCommand regCompCmd = new
OracleCommand("COMPOUND_PKG.REGISTERCOMPOUNDOPTMOLWEIGHT", rempOc);

                regCompCmd.CommandType =
System.Data.CommandType.StoredProcedure;

                //OracleParameter retParm = new
OracleParameter("RETURN_VALUE", OracleType.Number);
                OracleParameter retParm = new
OracleParameter("RETURN_VALUE", OracleDbType.Single);
                retParm.Size = 22;
                retParm.Direction =
System.Data.ParameterDirection.ReturnValue;
                regCompCmd.Parameters.Add(retParm);


                //OracleParameter nameParm = new OracleParameter("P_NAME",
OracleType.VarChar);
                OracleParameter nameParm = new OracleParameter("P_NAME",
OracleDbType.Varchar2);
                nameParm.Value = compound.Name;
                regCompCmd.Parameters.Add(nameParm);

                OracleParameter mwParm = new OracleParameter("P_MOLWEIGHT",
OracleDbType.Single);
                mwParm.Value = compound.MolecularWeight;
                regCompCmd.Parameters.Add(mwParm);

                OracleParameter anParm = new
OracleParameter("P_ALTERNATENAME", OracleDbType.Varchar2);
                anParm.Value = compound.AlternateName;
                regCompCmd.Parameters.Add(anParm);

                OracleParameter cdParm = new OracleParameter("P_CHANGEDATE",
OracleDbType.Date);
                cdParm.Value = new DateTime();
                regCompCmd.Parameters.Add(cdParm);

                regCompCmd.ExecuteScalar();
                return Convert.ToInt32(retParm.Value);

How would I translate this into a data map?

Thanks,
Ira


------------------------------------------------------------------------------
Notice:  This e-mail message, together with any attachments, contains 
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New 
Jersey, USA 08889), and/or its affiliates (which may be known outside the 
United States as Merck Frosst, Merck Sharp & Dohme or MSD and in Japan, as 
Banyu) that may be confidential, proprietary copyrighted and/or legally 
privileged. It is intended solely for the use of the individual or entity named 
on this message.  If you are not the intended recipient, and have received this 
message in error, please notify us immediately by reply e-mail and then delete 
it from your system.
------------------------------------------------------------------------------