freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds)

From: brlewis AT alum.mit.edu
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds)
Date: 10 Sep 2001 12:16:46 -0400

"Anton van Straaten" <anton AT appsolutions.com> writes:

> create procedure spTestExec as
> create table #tmp ( Result varchar(50) )
> insert #tmp execute spTestExec2
> select * from #tmp

You're going against 6.5 and still aren't in the habit of putting "set
nocount on" at the beginning of every stored procedure? I can hardly
get anything to work without it.

--
Bruce R. Lewis http://brl.sourceforge.net/

Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/09/2001
- <Possible follow-up(s)>
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), PMoore, 09/09/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Bob Kline, 09/10/2001
  - Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Bob Kline, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), brlewis, 09/10/2001
- Re: Why can't this stored procedure be called? (FreeTDS_JDBC and jtds), Anton van Straaten, 09/10/2001