How does one write a Java Stored Procedure?

Java Stored Procedures must comply with the following rules:

  • No constructor method is needed
  • Variables and methods must be declared static
  • Use the default database connection (no userid/ password required, run in session)
  • Declare output variables as arrays
  public [/b]static[/b] void getEmpInfo(int empno, [/b]String[][/b] empName, [/b]int[][/b] salary) {