Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I use Oracle bind variables using ADO in Visual Basic?

Re: How do I use Oracle bind variables using ADO in Visual Basic?

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sat, 11 May 2002 13:34:32 GMT
Message-ID: <I59D8.9796$L76.321@rwcrnsc53>


Yes, I believe JDBC does also. One place I used to work thought that was silly and created a wrapper class so they could use named parameters. The class handled the ? assignment so the developer could use a named parameter for the bind variable. It sure made debugging etc. easier. Less chance of error.
Jim
"tojo" <tom_at_hotmail.com> wrote in message news:MPG.1746f71edb0d059998968a_at_news.t-online.de...
> In article <3cda313f$0$237$ed9e5944_at_reading.news.pipex.net>, n-
> litchfield_at_audit-commission.gov.uk says...
> > which reminds me of a question I've meant to ask a number of times. Is
it
> > possible to use named parameters rather than the question mark notation
in
> > ADO ?
> >
>
> It's sad, but no. ADO replaces the question marks with param values in
> the order you defined them. I think JDBC works the same way (but dont
> quote me). OO4O is clearly superior in this area.
>
> -- Tom
Received on Sat May 11 2002 - 08:34:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US