Inline parameter

[Leon van Tegelen <le...@cumquat.nl>]

Hi

Is it possible to specify the MODE of a parameter (IN/OUT/INOUT)  in an 
inline parameter ? Curently I'm using a parameter map as input for a 
stored procedure call, but I'd rather us a parameterClass.

Thanks in advance

Leon van Tegelen

-- 
Leon van Tegelen
Cumquat Information Technology
De Dreef 19
3706 BR Zeist

Tel: +31 (0)30-6940490
Mob: 06-23704686 
Fax: +31 (0)30-6940499
Email: Leon.vantegelen@cumquat.nl

Re: Inline parameter

[Clinton Begin <cl...@gmail.com>]

I'm actually with Leon on this one....I prefer inlining as much as possible, 
even if it means defining additional properties inside the inline parameter. 


If we are to ever fully support a full featured Java/C# config API (i.e. no 
XML), this might become more important...not only for parameters, but for 
(inline) results as well.

Cheers,
Clinton

On 7/5/05, Larry Meadors <la...@gmail.com> wrote:
> 
> I believe you can do something like this:
> #parmName,mode=OUT,jdbcType=NUMERIC#, but IMO, the real question is
> why?
> 
> Inline parameters are a great shortcut, but if you have already
> created a working parameter map, why mess around trying to make it
> work with an inline one when you lose both flexibility and readability
> doing so?
> 
> Larry
> 
> On 7/5/05, Leon van Tegelen <le...@cumquat.nl> wrote:
> > Hi
> >
> > Is it possible to specify the MODE of a parameter (IN/OUT/INOUT) in an
> > inline parameter ? Curently I'm using a parameter map as input for a
> > stored procedure call, but I'd rather us a parameterClass.
> >
> > Thanks in advance
> >
> > Leon van Tegelen
> >
> > --
> > Leon van Tegelen
> > Cumquat Information Technology
> > De Dreef 19
> > 3706 BR Zeist
> >
> > Tel: +31 (0)30-6940490
> > Mob: 06-23704686
> > Fax: +31 (0)30-6940499
> > Email: Leon.vantegelen@cumquat.nl
> >
> >
>

Re: Inline parameter

[Larry Meadors <la...@gmail.com>]

I believe you can do something like this:
#parmName,mode=OUT,jdbcType=NUMERIC#, but IMO, the real question is
why?

Inline parameters are a great shortcut, but if you have already
created a working parameter map, why mess around trying to make it
work with an inline one when you lose both flexibility and readability
doing so?

Larry

On 7/5/05, Leon van Tegelen <le...@cumquat.nl> wrote:
> Hi
> 
> Is it possible to specify the MODE of a parameter (IN/OUT/INOUT)  in an
> inline parameter ? Curently I'm using a parameter map as input for a
> stored procedure call, but I'd rather us a parameterClass.
> 
> Thanks in advance
> 
> Leon van Tegelen
> 
> --
> Leon van Tegelen
> Cumquat Information Technology
> De Dreef 19
> 3706 BR Zeist
> 
> Tel: +31 (0)30-6940490
> Mob: 06-23704686
> Fax: +31 (0)30-6940499
> Email: Leon.vantegelen@cumquat.nl
> 
>