Re: DAO & Oracle stored proceddures

ehh - of course DAO works with oracle..

haven't used it for years, so i have no code at hand

this is what i remember:

u can execute it "natively":

String s = "begin sp_doSomething p1 => 'v1', p2 => v2; end;"

then execute this string like a normal query, dunno the method...

or with a prepeared stmt (dunno the DAO name for it):

{call sp_doSomething (?, ?)}

"Peter Groen" <peter.m.groen_at_{RemoveThis}xs4all.nl> wrote in message news:3c3f8245$0$4584$e4fe514c_at_dreader3.news.xs4all.nl...
> If you want to use DAO (not ADO?) with ORACLE, you're screwed. DAO is the
> engine that runs MS-Access. And this is something else than ORA.
>
> HtH
> Peter
>
> "Charles" <clincoln8_at_attbi.com> wrote in message
> news:9ztU7.15983$xl6.1183577_at_rwcrnsc54...
> > Does anyone have a "working" example of VB code using DAO to initiate an
> > Oracle stored procedure? It doesn't have to return a record set.
> >
> > I appreciate your help
> >
> >
>
>
Received on Sat Jan 12 2002 - 12:36:56 CET