Re: DDL Parsing Code for VB?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 28 Jan 2003 17:22:31 +0100
Message-ID: <efbd3v0gb40rfifihufvk173h9fvbjj5fa@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 Tue Jan 28 2003 - 10:22:31 CST