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

Home -> Community -> Usenet -> c.d.o.server -> Re: Executing SQL Statements throught ADO

Re: Executing SQL Statements throught ADO

From: Keith Jamieson <keith_jamieson_at_hotmail.com>
Date: Thu, 4 Dec 2003 20:40:46 -0000
Message-ID: <jZMzb.3265$nm6.18022@news.indigo.ie>


Mark,
you would be better off putting the required code into Packages/procedures and calling the procedures directly from ADO.

Keith Jamieson

"Mark Filson" <mfilson29NOSPAM_at_hotmail.com> wrote in message news:USMzb.9520$d35.1455_at_edtnps84...
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message
> news:kf5vsv4ud6fo4nqcopdt1db3d88n42td1s_at_4ax.com...
> > On Thu, 04 Dec 2003 20:02:25 GMT, "Mark Filson"
> > <mfilson29NOSPAM_at_hotmail.com> wrote:
> >
> > >Hi All,
> > >
> > >Here's the issue I'm having... I have a VB COM component that is used
to
> > >parse SQL files and apply them to an instance of Oracle. Most of the
> > >statements in the sql file work but a few don't. Here is an example of
> an
> > >offending one:
> > >
> > >
> > >CREATE OR REPLACE TRIGGER TR_SEQ_APPLICATION_SETTINGS
> > >AFTER INSERT OR UPDATE ON APPLICATION_SETTINGS
> > >FOR EACH ROW
> > >BEGIN
> > > SELECT SEQ_APPLICATION_SETTINGS.nextval INTO :new.ID FROM dual;
> > >END TR_SEQ_APPLICATION_SETTINGS;
> > >/
> > >
> > >
> > >The Sequence that's referenced is created successfully and my code says
> that
> > >the trigger is created (ie, no errors are thrown), but when I attempt
to
> > >insert a bunch of values into the table APPLICATION_SETTINGS, errors
are
> > >generated. Is there something about the syntax of this create
statement
> > >thats wrong. For what it's worth, the above statement can be run in
SQL
> > >PLUS successfully and the trigger is created.
> > >
> > >Cheers.
> > >
> >
> > The idea of being capable or to allow anyone to run DDL statements
> > through a VB com component is just horrible and shouldn't be even
> > considered as you would give ALL control to your database out of hand.
> > If you want to end up in HELL, go ahead, but other people may stay
> > well miles away of it.
> >
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
>
> Gee, thanks for the constuctive comments. For your information this
> component will be run by SYS ADMINS, not average users.
>
>
Received on Thu Dec 04 2003 - 14:40:46 CST

Original text of this message

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