You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Brjc <br...@gmail.com> on 2007/12/11 20:43:58 UTC
Derby Style table functions
Hi Iam trying to create a table function which returns a JDBC ResultSet. For
this Iam follwing the documentation provided here
http://db.apache.org/derby/docs/dev/devguide/cdevspecialtfbasic.html
When Iam trying to register my function by ising the below mentioned
construct I get a syntax error which says Syntax error: encountered TABLE at
line xxx, colum xx
CREATE FUNCTION createviews
()
RETURNS TABLE
(
WSID INT,
WSNAME VARCHAR( 255 )
)
LANGUAGE JAVA
PARAMETER STYLE DERBY_JDBC_RESULT_SET
NO SQL
EXTERNAL NAME 'com.views.create'
Is there something which Iam missing out.
Any help is greatly appreciated.
Cheers
Brjc
--
View this message in context: http://www.nabble.com/Derby-Style-table-functions-tp14281733p14281733.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby Style table functions
Posted by Rick Hillegas <Ri...@Sun.COM>.
Brjc wrote:
> Hi Iam trying to create a table function which returns a JDBC ResultSet. For
> this Iam follwing the documentation provided here
> http://db.apache.org/derby/docs/dev/devguide/cdevspecialtfbasic.html
>
> When Iam trying to register my function by ising the below mentioned
> construct I get a syntax error which says Syntax error: encountered TABLE at
> line xxx, colum xx
>
>
> CREATE FUNCTION createviews
> ()
> RETURNS TABLE
> (
> WSID INT,
> WSNAME VARCHAR( 255 )
> )
> LANGUAGE JAVA
> PARAMETER STYLE DERBY_JDBC_RESULT_SET
> NO SQL
> EXTERNAL NAME 'com.views.create'
>
> Is there something which Iam missing out.
> Any help is greatly appreciated.
>
> Cheers
> Brjc
>
Hi Brjc,
Your syntax works fine for me when I run my tests in the development
trunk. Maybe you are running your experiment against an official release
of Derby like 10.2 or 10.3? Table Functions will be introduced in the
10.4 release, due out in the first quarter of next year.
Hope this helps,
-Rick