[DB-SIG] DCOracle2 and callproc

[Marcos Sánchez Provencio]

El jue, 02-01-2003 a las 16:23, Matthew T. Kromer escribió:
> Marcos Sánchez Provencio wrote:
> 
> >Happy new year from Madrid
> >
> >I am using DCOracle2 to access Ora9i in Linux. I have a bunch of
> >preocedures in a package that were designed to be used from ADODB in
> >Visual Basic. They return a resultset, so they act similar to
> >Sybase/MSSQL stored procedures. I have managed to execute them and the
> >results look fine, but the description shows nothing.
> >
> >Is there any solution (besides knowing in advance the columns returned)
> >
> >This is the code:
> >
> >cur=con.cursor()
> >   
> >ret,res=cur.callproc('SOCOWNER.APP_ModoLista.APP_ModoLista','jaen',None)
> >print ret,res.description
> >print res.fetchall()
> >
> >###Results are
> >jaen None
> >[['DEN', 'Denominaci\xf3n', 'a', 2.0, '-', None], ['SEC', 'Fecha
> >Inscripci\xf3n', 'bFechas', 3.0, '-', None], ['AMB', '\xc1mbito',
> >'cambito', 4.0, '-', None], ['FAS', 'Fases', 'dfase', 5.0, '-', None],
> >['CLA', 'Clasificaci\xf3n Inscritas', 'fcla', 6.0, '-', None], ['PER',
> >'Intervinientes', 'm', 7.0, '-', None], ['EST', 'Listados', 'Informes',
> >8.0, '-', None], ['LOT', 'Tramitaci\xf3n', 'elot', 9.0, '-', None],
> >['DOC', 'Mantenimiento Firmantes', 'Documentos', 10.0, '-', None],
> >['LOC', 'Localidades', 'Localidad', 11.0, '-', None], ['VIN',
> >'Mantenimiento Car\xe1cter', 'ClasiSub', 12.0, '-', None]]
> >
> >Thanks
> >
> >
> >  
> >
> 
> Newer versions of the python part of DCOracle2 should automatically 
> describe a result cursor from a stored procedure so that the description 
> attribute is pre-set.  You can also call cursor.describe() to force the 
> description to be re-fetched, but I'd just suggest you check out the 
> latest CVS copy.
> 
> 
> 
The describe() did not work, but the CVS version did fine. Thank you.

-- 
Marcos Sánchez Provencio <msanchez@grupoburke.com>
www.burke.es