[ http://issues.apache.org/jira/browse/DERBY-1212?page=comments#action_12374351 ]
Daniel John Debrunner commented on DERBY-1212: ---------------------------------------------- It is best to ask these type of questions on derby-user before entering a Jira entry. Jira entries are for bugs and feature requests, not questions. Does this information help you? http://wiki.apache.org/db-derby/DerbySQLroutines > Problem in calling a function !! > -------------------------------- > > Key: DERBY-1212 > URL: http://issues.apache.org/jira/browse/DERBY-1212 > Project: Derby > Type: Bug > Versions: 10.0.2.0 > Environment: embedded driver > Reporter: Dheeraj Dhiman > Priority: Blocker > > I want to know about how to call a function !! > My case is :: > I have create a function like this ; > create function result(id bigint) returns varchar(34) PARAMETER STYLE JAVA NO > SQL LANGUAGE JAVA EXTERNAL NAME 'testderby.function.result'; > class function{ > public static String result(long id){ > connection conn; > Statemnt stmt ; > stmt = conn.createstatement(); > ResultSet rs = stmt.excuteQuery("select col1 from tablename"); > while(rs.next()){ > String str= rs.getString(1); > System.out.println(str); > } > } > } > so now how can i call this function from ij > prompt !! > or from any main function of a class !! > Pls give respose as early as possible !! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
