[Db-derby Wiki] Update of "DerbySQLroutines" by jeanTanderson

[Apache Wiki <wi...@apache.org>]

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 jeanTanderson:
http://wiki.apache.org/db-derby/DerbySQLroutines

The comment on the change is:
added some anchors

------------------------------------------------------------------------------
  [[TableOfContents(2)]]
  
  == Functions vs. Procedures ==
+ [[Anchor(FunctionsVsProcedures)]]
  
  There is overlap between SQL Functions and Procedures, 
  but each can also do things the other cannot and the syntax for invoking each is different.
@@ -46, +47 @@

  ||Execute in a SQL expression||no||yes||
  
  == Creating Functions ==
+ [[Anchor(Creating Functions)]]
  
  The [http://db.apache.org/derby/docs/dev/ref/rrefcreatefunctionstatement.html Reference Guide] provides the syntax for creating functions.
  
@@ -65, +67 @@

   * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200501.mbox/%3c41DAC70D.7000002@debrunners.com%3e A function that converts a Timestamp to its corresponding Long value using Java]
  
  == Creating Procedures ==
+ [[Anchor(Creating Procedures)]]
  
  The [http://db.apache.org/derby/docs/dev/ref/rrefcreateprocedurestatement.html Reference Guide] provides the syntax for creating procedures.
  
@@ -132, +135 @@

   * Returning less !ResultSets than defined by the DYNAMIC RESULT SETS clause is ok, only fill in the number of arrays you need. So in this example to only return one !ResultSet either just set data1[0] to the !ResultSet or data2[0] to the !ResultSet. Remember the order returned through !CallableStatement is driven by the order of creation, not the order of the method's parameters.
  
  == The power of Java in SQL ==
+ [[Anchor(ThePowerOfJavaInSql)]]
+ 
  The ability to write functions and procedures in Java brings the complete set of Java
  apis into your SQL environment as server side logic. A function or procedure may call
  any of the standard Java libraries, any of the standard Java extensions, or other third