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

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

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