db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Norman <mwnor...@gmail.com>
Subject Re: cannot create a function with no arguments
Date Thu, 06 Sep 2007 15:16:46 GMT

that did it - thanks!


Hi  Mike,

I think the problem is the datatype of the function's return value. The 
VARCHAR datatype needs a length. This should work:

CREATE FUNCTION FUNC_NO_ARGS() RETURNS VARCHAR( 100 )
...

Hope this helps,
-Rick


-- 
View this message in context: http://www.nabble.com/cannot-create-a-function-with-no-arguments-tf4392364.html#a12524824
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message