[python-sybase] Problems invoking stored procedures

Marcos Sánchez Provencio msanchez at grupoburke.com
03 Dec 2002 17:51:03 +0100


--=-0Zd7l6d9se4Enw/Pnnlq
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

VB seems to store these in a connection-level variable and/or associate
callback/event procedures. It might be a good solution, especially for
warnings and informative messages.

El vie, 29-11-2002 a las 06:00, Dave Cole escribi=F3:
> >>>>> "hopfgartner" =3D=3D hopfgartner  <hopfgartner@rolmail.net> writes:
>=20
> >> You don't say whether or not you are using FreeTDS.  I also get
> >> segfaults in FreeTDS 0.60 when I try to call stored procedures.  I
> >> have not tried the current CVS version of FreeTDS.  Something to
> >> try a bit later.
> >>=20
> hopfgartner> Sorry, I've forgot to mention it. Indeed, I'm using
> hopfgartner> FreeTDS 0.6.
>=20
> That helps a bit.
>=20
> >> Is it an error to have the stored procedure error message reported
> >> as an exception?
> >>=20
> hopfgartner> This should not be an error from the SQL server, but I
> hopfgartner> will look closer to it. This is simply a message telling
> hopfgartner> that there are no FK referencing this table. When running
> hopfgartner> from Query Analyser, this message appears in the
> hopfgartner> 'Messages' tab, wheras results are in the 'Grid' tab.
>=20
> That raises the question of what I should do with messages from the
> stored procedure.  Should I simply discard the messages?
>=20
> hopfgartner> The same stored procedure does not give any error
> hopfgartner> messages when run from Query Analyser.
>=20
> It would be really helpful if you could send a fragment of SQL (no
> matter how trivial) that I could run here to set up the exactly same
> situation that you are seeing.
>=20
> - Dave
--=20
Marcos S=E1nchez Provencio <msanchez@grupoburke.com>
www.burke.es

--=-0Zd7l6d9se4Enw/Pnnlq
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Esta parte del mensaje esta firmada digitalmente

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQA97OD2TwXdxLmtmxsRAsqYAJ9b6MBmlSugkE0bI001rc5me1kvpgCfTKPE
xVP2jlHTdKwCwMoL+FGahOk=
=1kqH
-----END PGP SIGNATURE-----

--=-0Zd7l6d9se4Enw/Pnnlq--