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 jeanTanderson
Date Fri, 13 Jan 2006 00:58:04 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 jeanTanderson:
http://wiki.apache.org/db-derby/DerbySQLroutines

------------------------------------------------------------------------------
  lowercase me!
  }}}
  
- '''Procedures''' are invoked with the {{{CALL}}} statement or the {{{CallableStatement}}}
method in a Java client application. Stored procedures support {{{IN}}}, {{{OUT}}}, and {{{INOUT}}}
parameters. If the stored procedure has just {{{IN}}} parameters, you can invoke it anywhere
with the {{{CALL}}} statement, including in ij. If the stored 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.
+ '''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.
  
- Here's an example of invoking built-in stored procedures using {{{ij}}}. The first loads
my 'myStuff.jar' jar file into the database and the second sets my database class path to
include that jar:
+ Here's an example of invoking built-in procedures using {{{ij}}}. The first loads my 'myStuff.jar'
jar file into the database and the second sets my database class path to include that jar:
  
  {{{
  ij> CALL SQLJ.install_jar
@@ -31, +31 @@

  }}}
  
  
- You can't invoke a sql function using {{{CALL}}} -- and you can't invoke a stored procedure
using {{{VALUES}}}. That's just one of the differences between them. More comparisons are
summarized in the table below:
+ You can't invoke a sql function using {{{CALL}}} -- and you can't invoke a procedure using
{{{VALUES}}}. That's just one of the differences between them. More comparisons are summarized
in the table below:
  
  ||'''Feature'''||'''Procedure'''||'''Function'''||
  ||Execute in a trigger||no||yes||

Mime
View raw message