Oracle 9i Merge available from OCI

[Nick Palmer]

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
?
We currently have merge logic in our OCI interface code to handle a merge
case, but it would be nice if I could replace this code with a direct call
to an OCI function.

Thanks,
Nick

[Norman Dunbar]

"Nick Palmer" <nick@kcicorp.com> wrote in message news:<vvrkmijvg1q6e8@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.

[Nick Palmer]

Norm, thanks for the reply.

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
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@lfs.co.uk> wrote in message
news:3078e2fe.0401090026.1beec6c9@posting.google.com... "Nick Palmer" <nick@kcicorp.com> wrote in message
news:<vvrkmijvg1q6e8@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.

[Norman Dunbar]

Morning Nick,

"Nick Palmer" <nick@kcicorp.com> wrote in message news:<100846mbq07sh47@corp.supernews.com>...

Norm, thanks for the reply.

Welcome.

You basically found what I found in your PS. It seems that there is no notion of merge in any of the OCI stuff.

True, but .......
I haven't tried doing a small sample because it didn't seem like there was any support for merge in OCI. Maybe I'll give it a shot.

Ah well, I was bored last night in my B&B (I'm away from home) so I
fired up the trusty laptop and 'wrote' a small example - straight out
of the SQL Manual example, and, "it just works".

I didn't bother trying to determine the statement type - I leave that
as an exercise for the reader :o)


Cheers,
Norm.

Still having to Google - we are tied down tighter than a duck's bottom
here.
Don't reply to the email address it is an old one which I can't get
access to change at the moment - still, less spam that way.