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

[Anthony T. <ant...@gm...>]

Hi, I am on holidays right now but when I get back I can make sure
that the relevant code is in place for the next release. Its likely
just a simple OCI call that will only take about 5-10 minutes to
do.... :-)

Anthony

On Mon, Jun 14, 2010 at 7:15 AM, Weber, Geoffrey
<Geo...@pa...> wrote:
> 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
>
> ------------------------------------------------------------------------------
> 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
>