db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by KatheyMarsden
Date Thu, 24 Jan 2008 21:27:15 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by KatheyMarsden:
http://wiki.apache.org/db-derby/DerbySQLroutines

------------------------------------------------------------------------------
  -------------
  lowercase me!
  }}}
- 
- Another example is using a function for LanguageBasedOrdering.
  
  '''Procedures''' are invoked with the {{{CALL}}} statement or the {{{CallableStatement}}}
method in a Java client application.  Procedures support {{{IN}}}, {{{OUT}}}, and {{{INOUT}}}
parameters. If the procedure has just {{{IN}}} parameters, you can invoke it anywhere with
the {{{CALL}}} statement, including in ij. If the procedure has {{{OUT}}} or {{{INOUT}}} parameters,
it can't be invoked from ij, it must be invoked from a client application using the {{{CallableStatement}}}
method. Starting in [http://issues.apache.org/jira/browse/DERBY-551 Derby 10.2], a java procedure
can also be invoked in a trigger.
  

Mime
View raw message