Skip to Content.
Sympa Menu

freetds - [freetds] stored procs

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris McDaniel" <Chris.McDaniel AT telus.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] stored procs
  • Date: Sat, 21 Dec 2002 01:25:22 -0700

Hello,

First, thanks to everyone - I can now connect and run stored procs with the
latest and greatest CVS checkout, so Thanks!

I'm trying to get a result back from a stored procedure in an ms sql db and
I'm having no luck at all. I do know that the stored proc is using the
following snippet to return it's message:

/* result */
declare @Msg varchar (254)
select @Msg = 'Return code was: ' + convert(varchar, @RetCode)
print @Msg
select @Msg = 'Availability : ' + convert(varchar, @AvailableInd)

print @Msg
select @Msg = 'Information : ' + @Information
print @Msg
select @Msg = 'ConferenceRef=' + convert(varchar, @ConferenceRef) + ', DDI='
+ @DDI + ', CPIN=' + @CPIN + ',MPIN=' + @MPIN
print @Msg
GO

and I'm wondering how I can get at the return. I'm testing with isql and
developing in perl, and I've gotten nowhere. Can anyone help me out?

Thanks,

Chris




  • [freetds] stored procs, Chris McDaniel, 12/21/2002

Archive powered by MHonArc 2.6.24.

Top of Page