Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

26-12.	Put the following steps for accessing a Java class from PL/SQL in order: Grant the necessary privileges on the PL/SQL wrappers. Use javac (or an Integrated Development Environment such as JDeveloper ) to compile the Java code. Write PL/SQL wrappers to publish the class’ methods. Call the PL/SQL wrapper programs. Use loadjava to load the class into the database.
26-13.	Show the operating system commands that load the following class into the SCOTT (password TIGER) schema: public class helloWorld { public static void doit () { System.out.println("Hello World!!!"); } }
26-14.	Show the Oracle8i DDL command that loads the following class into the database: public class helloWorld { public static void doit () { System.out.println("Hello World!!!"); } }
26-15.	What clause must you include in a function or procedure header to create a call spec for a Java method? PARALLEL_ENABLE LANGUAGE JAVA JAVA SPEC AUTHID USER DETERMINISTIC
26-16.	What is the Java equivalent of the command SET SERVEROUTPUT ON?
26-17.	To publish a void Java method, you should use a PL/SQL: Function Blob Procedure Index-by table External procedure
26-18.	For each PL/SQL datatype in the left column, provide a corresponding Java datatype (there are many possible answers): PL/SQL Datatype Java Equivalent VARCHAR2   DATE   NUMBER (integer)   NUMBER (real)   ROWID   OBJECT   RAW
26-19.	Write a call spec for the following Java class: public class OutputTest { public static void printIt (String s) { System.out.println (s); } }
26-20.	Write a call spec for ...