Expert

26-22.

Describe what happens when the call spec specified for the following class is created and executed:

public class helloWorld {
   public static void doit () {
       System.out.println("Hello World!!!");
   }
}

-- Call spec used for the class
CREATE OR REPLACE PROCEDURE my_hello
AS LANGUAGE JAVA
NAME 'helloWorld.doIt()';

26-23.

Describe what happens when the call spec specified for the following class is created and executed:

public class helloWorld {
   public void doit () {
       System.out.println("Hello World!!!");
   }
}

-- Call spec used for the class
CREATE OR REPLACE PROCEDURE my_hello
AS LANGUAGE JAVA
NAME 'helloWorld.doit()';

26-24.

Write a query to display information about the Java objects in a user schema.

26-25.

Write a procedure to print the source code for a Java-stored procedure (assuming, of course, that the source has been loaded).

26-26.

Write a call spec for the following Java class:

public class NumberTest{
  public static void smallestFirst (int[] a, int[] b) {
    int tmp = a[0];
    if (a[0] > b[0]) {
       a[0] = b[0];
       b[0] = tmp;
    }
  }
}

26-27.

Complete the following call spec:

CREATE OR REPLACE FUNCTION wages (e Employee) RETURN NUMBER
AS LANGUAGE JAVA
NAME 'Paymaster.wages( xxx ) return BigDecimal';

26-28.

You have been asked to design a PL/SQL interface for a subset of the methods in a Java file-manipulation class. Specifically, you are to write two functions and one procedure: a function that deletes a given file and returns a Boolean flag indicating whether the delete succeeded; a function that ...

Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.