[python-sybase] Problems invoking stored procedures
Dave Cole
djc at object-craft.com.au
29 Nov 2002 16:00:01 +1100
>>>>> "hopfgartner" == hopfgartner <hopfgartner@rolmail.net> 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