Re: [cx-oracle-users] Setting listening port for DatabaseChangeNotification feature...

[Weber, G. <Geo...@PA...>]

I've done some more digging and found the OCI call that will do the same thing: http://www.comp.dit.ie/btierney/oracle11gdoc/appdev.111/b28395/oci09adv.htm#CJGDFFFJ

Depending on my time, I may try to take a quick look at the driver code to see if this is there or I can insert it somehow.  I'm really hesitant to take that last step, however, as I probably just know enough to get into trouble instead of accomplish what I set out to do there :D...



________________________________________
From: Weber, Geoffrey [Geo...@PA...]
Sent: Monday, June 14, 2010 8:18 AM
To: cx-...@li...
Subject: [cx-oracle-users] Setting listening port for   DatabaseChangeNotification feature...

I've discovered with Anthony's help that a bug in Oracle causes Python3.1 to not understand DCN callbacks in 10g or 11gR1.  So now I'm using 11gR2 and things test out locally just fine.  However, my environment is strictly controlled and firewall connections are managed on a one-off basis.

...so basically now I need to be able to specify the listening port of the DCN client (Python side of the connection).  Unless this is specified as an option, Oracle chooses a port at random.  Obviously in my environment, this will not work for me.  I am unable to find such a parameter in either the Connection object or register function call (or anything else in the docs), and I didn't find anything in the driver source code using 'grep' either.  As an example, JDBC has a parameter found in this table: http://www.comp.dit.ie/btierney/oracle11gdoc/java.111/b31224/dbmgmnt.htm#CHDBDJHC called "NTF_LOCAL_TCP_PORT".

Is it possible to set parameters on connections as in the JDBC driver?

Thanks!
    Geoff Weber
    geo...@pa...



------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit.  See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users