FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Chris McDaniel [mailto:Chris.McDaniel AT telus.com]
> Sent: January 6, 2003 10:34 AM
> 
> Does anyone know why I'm not getting any data out of the 
> @params marked
> OUTPUT in the proc? 

Chris, 

You're using brand new functionality.  Frediano added support for output
parameters in December, and I'm not sure anyone's tried to use it yet with
perl.  

Post the last 500 lines of your TDSDUMP log.  It should show what's going
on.  Maybe perl requires an ODBC feature we don't support (yet), or it's
calling the driver in a way we didn't anticipate.  

Thanks for your help debugging this.  :)

--jkl

> $sth = $dbh->prepare('execute p_ccs_MakeBooking 
> @ClientAccount="xxxxxx",
> @PaymentNumber="xxxxxx", @ConferenceName="Scripts: 06:47 Booked",
> @ConferenceComments="Created by Chris McDaniel", @ConferenceType=1,
> @LanguageType=1, @PriorityType=2, @StartDateTime="2003-02-01 
> 12:30:00",
> @Duration=10, @Conferees=3, @SubConferees=0, @TollFreeInd=1,
> @RecordingInd=1, @EnterToneInd=1, @LeavingToneInd=1, @QandAInd=1,
> @PollingInd=1, @RollCallInd=1, @BroadcastInd=1, @DemandInd=0,
> @ModeratorInd=1, @AutoPINInd=1, @DDI=?, @CPIN=?, @MPIN=?,
> @RecordingPIN="555", @Information=?, @ReservationRef=?, 
> @ConferenceRef=?,
> @ActualDuration=?, @AvailableInd=?');
> 
> $sth->bind_param_inout(1, \$DDI, 32, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(2, \$CPIN, 12, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(3, \$MPIN, 12, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(4, \$Info, 255, DBI::SQL_VARCHAR);
> $sth->bind_param_inout(5, \$ResRef, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(6, \$ConfRef, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(7, \$ActDuration, 10, DBI::SQL_INTEGER);
> $sth->bind_param_inout(8, \$AvailInd, 1, DBI::SQL_BIT);
> $sth->execute();


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.