Oracle PL/SQL Programming: A Developer's Workbook

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 ...