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: Summit <noreply_at_noreply.us>
Date: Mon, 08 Dec 2003 15:44:41 GMT
Message-ID: <J%0Bb.904$23.500@nwrddc01.gnilink.net>

"Turkbear" <john.g_at_dot.spamfree.com> wrote in message news:2bt1tv4982av4vfhra2pr0j46e9o5jpf1c_at_4ax.com...
> "Mark Filson" <mfilson29NOSPAM_at_hotmail.com> wrote:
>
> Snip-------------------
> >
> >That's the thing. There aren't any errors generated. It's just that the
> >code to create the trigger, which contains the text ' :new ' does not get
> >passed to Oracle. All the other ddl script is passed successfully to
> >Oracle.
> >
> >A side note: Instead of using the Oracle OLEDB provider, I tried using
the
> >Microsoft Oracle OLEDB provider and the triggers are created
successfully.
> >
> >
> >
> I have found the same thing..
> I usually think the Driver made by the Database company is better, but I
have mostly used Microsoft's for Oracle instead of
> Oracle's own..( Perhaps Bill is hiding something from Larry ;-) )
>
>
> Odd...
>
> I haven't tried much with the v9.2 Oracle OLEDB Provider, maybe they have
fixed things..
>
>
>
Received on Mon Dec 08 2003 - 09:44:41 CST

Original text of this message

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