DCOracle

[Oleg Broytmann]

On Thu, 27 Apr 2000, Darren Young wrote:
> Any pointers on examples of working code out there?

from DCOracle import Connect
jwt = Connect("%s/%s@%s" % (login, password, SID))

cursor = jwt.cursor()                                                           
format = "%s | "*13 + "%s\n"                                                    
                                                                                
cursor.execute("SELECT * FROM sides_view")                                      
while 1:                                                                        
   olist = cursor.fetchmany(10)                                                 
   if not olist: break                                                          
   for row in olist:                                                            
      sys.stdout.write(format % row)                                            
                                                                                
cursor.close()                                                                  
jwt.close()

Oleg.            (All opinions are mine and not of my employer)
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd at phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.