Re: [cx-oracle-users] subscribe in cx_oracle

[Mark H. <mh...@pi...>]

On 11/10/10 4:45 PM, Mark Bell wrote:
> I'm testing the subscribe() for change notification, but I'm having some


> it doesn't give any errors, but doesn't report any changes. Am I doing something
> wrong?

Are you on 10g RAC?  If so, it's busted.  The DB should save off the address/port
of your client process, but it instead saves off the address of whatever database
node you've attached to.

I was about to go insane talking to oracle support:

"change notification doesn't work on RAC"
"we dont support python"
"type in the example OCI code from your docs.  It won't work on RAC"
"what application server are you using?"
"none, im typing in the OCI code example."
"is this a java app?"
"no, OCI is for C"
"what application are you running? peoplesoft?"
"no, the example OCI code in your docs"
"in the java"
"no, OCI is for C.  PLEASE type in the example and you will see it bust"
"can you send me your SQL query?"
"no, it's not a query, it's a change notification. look at your docs"

[escalation due to sales intervention]

"change notification doesn't work on RAC"
"we dont support python"
"type in the example OCI code from your docs.  It won't work on RAC"
"what application server are you using?"
"none, im typing in the OCI code example. its in the book but i'll send you a copy"

[days pass]

"it works great on my test system"
"are you on RAC?"
"no"

etc etc etc

There's a patch for 10gR2.