Posted by helmut woess on 10/24/05 19:40

Am 24 Oct 2005 08:17:01 -0700 schrieb rey@infoman.de:

....
> -----
> Call of the function with:
> exec dbo.F_FUNCTION 550,1632, 0, ''
>
> Here the beginning of the query analyser output:
>
> 1.00000*-*691*-*1684*-*3*-*0*-**-*0*-*2005-09-22T00:43:00*-*277
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '*'.
>
> -----

ntext is a valid datatype for the OUTPUT variable of a stored procedure.
This is not the problem. Your error appears here:
....
-- Part Output
print @onelevel

if (@return is NULL)
exec(@return+@onelevel)
else
exec(@return+'*;*'+@onelevel)
....
because if @return is Null then you do a
exec('1.00000*-*691*-*1684*-*3*-*0*-**-*0*-*2005-09-22T00:43:00*-*277')
and what should this be?
EXEC starts another stored proc, from there you get your error message. And
so it is an error in line 1.

bye
Helmut

• Next in forum: Re: Adding an auto-increment column to existing table with a particular order
• Prev in forum: Re: Many data entry tables - which ones hold records?
• Thread view: Re: Create Procedure Output ntext

[Reply to this message]