HOW TO: ADO 2.5 Oracle Stored Proc into Recordset

Article View: comp.databases.ms-access

Article #565

Back to comp.databases.ms-access Previous Next

#565

From: Hope Reyes
Date: Thu, 30 Nov 2000 00:00

26 lines
2873 bytes

Hi and thanks in advance...

Can somone give me syntax, and/or advice, and or references, that will allow
me to run an Oracle stored procedure from VB ADO 2.5 that will provide input
(criteria parameters) and return a resultant recordset on a DQL select
statement inside the stored proc?  Can one use a simple command object and
parameters collection or not?  I have a book (Visual Basic Oracle 8, wrox)
that says in older ADO this would not work and one needed a pass-through.
But we are trying to use OLE DB instead of ODBC.

I am interested in using Oracle stored procedures so that I may "reuse"
query syntax and simply provide parameters to what would ordinarily be a
simple SQL SELECT statement that executes joins and includes WHERE criteria.
I am trying to get away from the method of writing all SQL for Access 2000
forms, etc. in long VB strings.  These are not process oriented or business
rules stored proc's, but simply a way of mimicking what is possible with
straightforward Access "parameter queries".

If you have tips on using such a stored proc as the record source for an
Access form, report, or combo/list box please include that too!  I don't
know if the best method will be trying to set the form's recordset property,
etc... still investigating.

Thanks again,

Hope Reyes

Technical Details

Message-ID: <SswV5.18786$II2.1855235@newsread2.prod.itd.earthlink.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,cd9961d7c9ae3002,start
X-Google-Attributes: gidfb53f,public
X-Google-Thread: 10845c,cd9961d7c9ae3002,start
X-Google-Attributes: gid10845c,public
X-Google-Thread: ff0ac,cd9961d7c9ae3002,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f99a8,cd9961d7c9ae3002,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: fb992,cd9961d7c9ae3002,start
X-Google-Attributes: gidfb992,public
X-Google-Thread: 109d21,cd9961d7c9ae3002,start
X-Google-Attributes: gid109d21,public
X-Google-Thread: 115acd,cd9961d7c9ae3002,start
X-Google-Attributes: gid115acd,public
X-Google-Thread: fe218,cd9961d7c9ae3002,start
X-Google-Attributes: gidfe218,public
From: "Hope Reyes" <hopealso@my-deja.com>
Subject: HOW TO:  ADO 2.5 Oracle Stored Proc into Recordset
Date: 2000/11/30
Message-ID: <SswV5.18786$II2.1855235@newsread2.prod.itd.earthlink.net>
X-Deja-AN: 699598423
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread2.prod.itd.earthlink.net 975606706 165.247.46.36 (Thu, 30 Nov 2000 09:51:46 PST)
Organization: EarthLink Inc. -- http://www.EarthLink.net
X-MSMail-Priority: Normal
NNTP-Posting-Date: Thu, 30 Nov 2000 09:51:46 PST
Newsgroups: comp.databases.ms-access,comp.databases.oracle.misc,comp.lang.visual.basic,hannover.uni.comp.oracle,microsoft.public.access.externaldata,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba.ado,microsoft.public.data.ado,micros