Re: Problems invoking stored procedures

Dave Cole <[email protected]>
Newsgroups gmane.comp.python.sybase
Message-ID <[email protected]>
>>>>> "hopfgartner" == hopfgartner  <[email protected]> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.