Re: Stored Procedure - ODP.NET

[Roberto R <ro...@gmail.com>]

Hi Eka,

Yes, property refers to your object property.  In 1.3, you don't declare the
class, but recent changes in SVN to improve the DataMapper will now require
you to declare the class.  The parameter order is what is currently used.
Here's what's currently in SVN:

        <procedure id="InsertAccountViaStoreProcedure"
parameterMap="insert-params">
            prc_InsertAccount
        </procedure>
...
        <parameterMap id="insert-params" class="Account">
            <parameter property="Id"/>
            <parameter property="FirstName" dbType="Varchar2" size="32"/>
            <parameter property="LastName" dbType="Varchar2" size="32"/>

            <parameter property="EmailAddress" dbType="Varchar2" size="128"
nullValue="no_email@provided.com"/>
            <parameter property="BannerOption"  dbType="Varchar2"
type="bool"/>
            <parameter property="CartOption"    column="Account_Cart_Option"
typeHandler="HundredsBool"/>
        </parameterMap>

On 3/31/06, Eka Gautama <ek...@seatech.com> wrote:
>
> Hi all,
>
> I was trying to access the oracle db with ODP.NET. I saw the sample in
> DataMapperGuide, version 1.3 and I am a bit confuse. Here I paste the code
> taken from that pdf file
>
> *<!-- Oracle with ODP.NET 10g provider -->*
> **
> *<statement id="InsertAccount" parameterMap="insert-params">*
> *    prc_InsertAccount*
> *</statement>*
> *...*
> *<parameterMap id="insert-params">*
> *    <parameter property="Id" dbType="Int32"/>*
> *    <parameter property="FirstName" dbType="VarChar2" size="32"/>*
> *    <parameter property="LastName" dbType="VarChar2" size="32"/>*
> *    <parameter property="EmailAddress" dbType="VarChar2" size="128"/>*
> *</parameterMap>*
> **
>
> Couple questions :
>
> - what does attribute *property* for? is it for the Property of my object?
> If yes, where I have to declare the object, because i didn't see any
> object/class (parameterClass) on above code.
> - Do I have declare the name of my storedprocedure parameters?
>
> Thanks
>
> Eka
>
>