Why is Output parameter null?

Question

Post reply

Why is Output parameter null?

Tobar

SSCarpal Tunnel

Points: 4876
More actions
April 1, 2013 at 12:31 pm

#291618

Can someone explain why @p2 is null/empty?
begin try drop procedure TestOut end try begin catch end catch
go
create procedure TestOut
@P1 varchar(256),
@p2 varchar(MAX) OUTPUT
as
if @p1 = 'Y'
set @p2 = 'Yes'
else
set @p2 = 'Not Y'
go
/*
declare @p2 varchar(max)
exec Testout 'Y', @p2
if @p2 IS NULL
print 'nothing'
else
print 'P2 is ' + @p2
*/
Thanks
<><
Livin' down on the cube farm. Left, left, then a right.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

I believe when you call the procedure, you need to mark the parameter as output also:

exec Testout 'Y', @p2 OUTPUT

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Lowell is correct.

create procedure TestOut

@P1 varchar(256),

@p2 varchar(MAX) OUTPUT

as

if @p1 = 'Y'

set @p2 = 'Yes'

else

set @p2 = 'Not Y'

go

declare @p2 varchar(max)

exec Testout 'Y', @p2 output

if @p2 IS NULL

print 'nothing'

else

print 'P2 is ' + @p2

drop procedure TestOut;

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 3

argh!! Documentation example shows that as well. Sorry I didn't see it before.

<><
Livin' down on the cube farm. Left, left, then a right.