Re: Oracle 9i Merge available from OCI
Date: 9 Jan 2004 00:26:03 -0800
Message-ID: <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>
[Quoted] 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 Fri Jan 09 2004 - 09:26:03 CET