Re: Executing SQL Statements throught ADO

"Mark Filson" <mfilson29NOSPAM_at_hotmail.com> wrote in message news:0xNzb.9535$d35.6492_at_edtnps84...
>
> "mcstock" <mcstock @ enquery .com> wrote in message
> news:RYOdnfTT6fbmPFKiRVn-gw_at_comcast.com...
> > "Mark Filson" <mfilson29NOSPAM_at_hotmail.com> wrote in message
> > news:lpMzb.9514$d35.2257_at_edtnps84...
> > | 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;
I'm no developer, but that ":new" looks distinctly dodgy to me. I'm almost certain the ":" is not going to be read correctly.

Not entirely sure what you'd do about it though. Scrub that: I haven't a clue what you'd do about it.

Sorry.

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------