db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brjc <brijesh.cho...@gmail.com>
Subject Derby Style table functions
Date Tue, 11 Dec 2007 19:43:58 GMT

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.


Mime
View raw message