Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL Parsing Code for VB?
I am using 8.1.7.0.0 Standard Edition, ODBC Driver 8.1.77.0
I guess the underlying question is;
Is there a way to run a multi-statement DDL script using pass-through
queries from Access?
Every method I try errors out if there is more than one statement ending with a ';' or a '/'.
Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<efbd3v0gb40rfifihufvk173h9fvbjj5fa_at_4ax.com>...
> On 28 Jan 2003 07:01:31 -0800, stevens_at_coloradocustomware.com (Steve
> S) wrote:
>
> >Does anyone know where I could get some VB parsing code that can be
> >used
> >to execute Oracle DDL scripts via DAO or ADO in Access 2002? I need
> >something that can parse out a script like;
> >
> >--this is a comment
> >create table ... yada yada...
> >/
> >--this is a comment
> >create index ... yada yada...
> >/
> >
> >
> >so I can execute them as 2 sperate pass through queries.
> >
> >I know I could write one myself, but I dont want to reinvent the
> >wheel if I dont have to.
> >
> >Thanks for any help.
> >
> >Steve
> >Colorado CustomWare
>
>
> I think a passthrough query would do or else a very small stored
> procedure in Oracle calling execute immediate or dbms_sql
> (depending on your Oracle version which you of course don't mention).
> So there is no need to re-invent the wheels, the only need is to read
> manuals.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Jan 29 2003 - 13:04:21 CST