Re: Oracle 9i Merge available from OCI

[Quoted] Norm, thanks for the reply.

[Quoted] You basically found what I found in your PS. It seems that there is no notion of merge in any of the OCI stuff. I haven't tried doing a small sample
[Quoted] because it didn't seem like there was any support for merge in OCI. Maybe I'll give it a shot.

Nick.

"Norman Dunbar" <norman.dunbar_at_lfs.co.uk> wrote in message news:3078e2fe.0401090026.1beec6c9_at_posting.google.com...
> "Nick Palmer" <nick_at_kcicorp.com> wrote in message
news:<vvrkmijvg1q6e8_at_corp.supernews.com>...
> > Hi all,
> >
> > I've been reading about the 9i "merge" feature. I understand how to
access
> > this using PL/SQL, but I'm curious. Is there a way to access this from
OCI
> > ?
> <SNIP>
>
> Hi Nick,
>
> Greetings from behind the firewall :o)
>
> I haven't tried it yet, but I'm pretty certain that all you do is
> build a 'merge' statement in the same way as you would an 'insert' in
> OCI, prepare, bind, define and execute as normal.
>
> In situations like this, I like to experiment and see what happens.
> Why not knock up a small test programn and try it out.
>
> Have fun.
>
> Norm.
>
> PS. Looking through oci.h, under statement types there isn't a value
> (in 9.2.0.3) for OCI_STMT_MERGE so I suspect it will either (a) not
> work or (b) simply be an OCI_STMT_INSERT. I also did a quick Windows
> Search to see if "merge" was in any of the demos - it is, but in
> comment fields. I Tried looking for "merge just in case, but found
> nothing. Not that Windows search is of much help - I need grep
> instead.
Received on Tue Jan 13 2004 - 16:38:56 CET