[DB-SIG] DCOracle2 and callproc

[Marcos Sánchez Provencio]

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


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