Re: [python-sybase] Problems invoking stored procedures

[Dave C. <dj...@ob...>]

>>>>> "hopfgartner" == hopfgartner  <hop...@ro...> writes:

>> 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.
>> 
hopfgartner> Sorry, I've forgot to mention it. Indeed, I'm using
hopfgartner> FreeTDS 0.6.

That helps a bit.

>> Is it an error to have the stored procedure error message reported
>> as an exception?
>> 
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.

That raises the question of what I should do with messages from the
stored procedure.  Should I simply discard the messages?

hopfgartner> The same stored procedure does not give any error
hopfgartner> messages when run from Query Analyser.

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.

- Dave

-- 
http://www.object-craft.com.au