return from stored procedure

[raghu3]

what is wrong with this sp:
create procedure tstSP @ret char(10)=null OUTPUT
AS
.
.
.

SET @ret='returnval'

RETURN @ret

when I execute this, I get the following message:
Syntax error converting the varchar value 'returnval' to a column of data type int.

On debug the value of @ret is set correctly.


I don't think this is that complicated ... but I am kind of stumped!

 

[vongrunt]

There is no need for RETURN... it has different purpose in stored procs and btw. accepts only integers.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[SQLDenis]

Read my answer in this thread thread183-1214421

It explains how to call a proc with output parameters

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[raghu3]

It does not care w/out the return. My sql connectd to ADSI via linked server, maybe there are different set of rules in this case. As I do a count(*) from ADSI, but get the ad attribute I select, this is only for validation.