Re: [cx-oracle-users] Help with fetchraw

[Chris D. <cdu...@ya...>]

Leith,

Thanks, I like the sub-classing idea but my OO Python isn't that good so if you could give me a
code example that would be much appreciated.

Thanks very much,

Chris
--- Leith Parkin <lei...@gm...> wrote:

> Hi Chris,
> 
> No worries. We have a very similair setup at work, transferring
> summarised data from oracle into MySQL.
> 
> Depending on the database you are transferring too, couldnt you set a
> trigger, inserting NULL (eg, a python None from Oracle) into the table
> generates an empty string?
> 
> Failing that, subclassing cx_Oracles cursor object to return a the
> empty string when the column type is textual and the value is null
> might be another option.
> 
> Good luck,
> 
> Leith
> 
> 
> On 5/13/05, Chris Dunscombe <cdu...@ya...> wrote:
> > Leith,
> > 
> > I didn't mention that for 1) the target table is in a separate database and using database
> links
> > isn't an option (although I wish it was) due to reasons that are too lengthy to go into here.
> > Hence  PL/SQL isn't really viable. So I'd still like to look at cursor.fetchraw()
> > 
> > Now for 2) you maybe right that PL/SQL could be used but I'll still have to write out to file
> > using Python as util_file can only write to files that the database server can "see" which
> isn't
> > always the case for my app.
> > 
> > Thanks for the idea,
> > 
> > Chris
> > 
> > 
> > --- Leith Parkin <lei...@gm...> wrote:
> > > This sounds like something better done in PL/SQL?
> > >
> > > Regards,
> > >
> > > Leith
> > > On 5/13/05, Chris Dunscombe <cdu...@ya...> wrote:
> > > > I'm looking to use cursor.fetchraw to help improve performance in an app I'm writing. I've
> > > looked
> > > > at CopyData from cx_OracleTools but I'm afraid I couldn't work it out.
> > > > If possible I'd like a simple full example to show me the way. The context is:
> > > >
> > > > 1) Retrieve rows from source table and insert into a target table which has exactly the
> same
> > > > structure.
> > > >
> > > > 2) Retrieve rows from source table, add some column formatting and write out to a file.
> > > >
> > > > Thanks very much,
> > > >
> > > > Chris Dunscombe
> > > >
> > > > PS Thanks for all the input re my previous posting on Nulls and None. I've still got some
> > > thinking
> > > > and work to do on which is best for performance and how best to cope with different
> datatypes,
> > > > particularly Longs (what a pain they are!!)
> > > >
> > > > __________________________________
> > > > Yahoo! Mail Mobile
> > > > Take Yahoo! Mail with you! Check email on your mobile phone.
> > > > http://mobile.yahoo.com/learn/mail
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > > > Want to be the first software developer in space?
> > > > Enter now for the Oracle Space Sweepstakes!
> > > > http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> > > > _______________________________________________
> > > > cx-oracle-users mailing list
> > > > cx-...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > > Want to be the first software developer in space?
> > > Enter now for the Oracle Space Sweepstakes!
> > > http://ads.osdn.com/?ad_ids93&alloc_id281&op=click
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> > >
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_ids93&alloc_id281&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com