Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Thu, 06 Sep 2007 07:12:20 -0700
From: Rick Hillegas <Richard.Hillegas@Sun.COM>
Subject: Re: cannot create a function with no arguments
In-reply-to: <12523237.post@talk.nabble.com>
Sender: Richard.Hillegas@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <46E00AC4.1080300@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <12523237.post@talk.nabble.com>
User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728)

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


Mike Norman wrote:
> latest Derby:
>   Apache Derby
>   10.3.1.4 - (561794)
>   Apache Derby Network Client JDBC Driver
>   10.1.2.1
>
> I have an extremely simple helper class:
>
>   package test;
>
>   import java.sql.SQLException;
>
>   public class SPHelper {
>
>       public static void ProcNoArgs() throws SQLException {
>       }
>     
>       public static String FuncNoArgs() throws SQLException {
>           return "gidday";
>       }
>   }
>
> The first external procedure works:
>
>   CREATE PROCEDURE PROC_NO_ARGS() 
>   LANGUAGE JAVA 
>   EXTERNAL NAME 'test.SPHelper.ProcNoArgs' 
>   PARAMETER STYLE JAVA
>   NO SQL
>
> but I cannot create a no-arg function:
>
>   CREATE FUNCTION FUNC_NO_ARGS() RETURNS VARCHAR
>   LANGUAGE JAVA
>   EXTERNAL NAME 'test.SPHelper.FuncNoArgs'
>   PARAMETER STYLE JAVA
>   NO SQL
>   CALLED ON NULL INPUT
>
> I get the following exception:
>
>  09:43:30  [CREATE - 0 row(s), 0.000 secs]  [Error Code: -1, SQL State:
> 42X01]  Syntax error: Encountered "LANGUAGE" at line 2, column 3.
> ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000
> sec [0 successful, 0 warnings, 1 errors]
>
> Any ideas?
>
>
>