Oracle PL/SQL Programming: A Developer's Workbook

Intermediate

Q:
26-12.	These steps for accessing a Java class from PL/SQL are now in order: Use javac (or an IDE such as JDeveloper) to compile the Java code. Use loadjava to load the class into the database. Write PL/SQL wrappers to publish the class’ methods. Grant the necessary privileges on the PL/SQL wrappers. Call the PL/SQL wrapper programs.
Q:
26-13.	The operating system commands that compile and load the helloWorld class are: javac helloWorld.java loadjava "u scott/tiger "force helloWorld.class
Q:
26-14.	The Oracle8i DDL command that loads the helloWorld class directly into the database is: CREATE OR REPLACE JAVA SOURCE NAMED "helloWorld" AS public class helloWorld { public static void doit () { System.out.println("Hello World!!!"); } };
Q:
26-15.	(b). You include the LANGUAGE JAVA clause in a function or procedure header to create a call spec for a Java method.
Q:
26-16.	Executing DBMS_JAVA.SET_OUTPUT (buffer size) is the equivalent of the command SET SERVEROUTPUT ON. You will not see any output from the Java’s System.out or System.err until you execute this command.
Q:
26-17.	(c). You should use a procedure to publish a void Java method.
Q:
26-18.	Here is the completed table (remember that there are many Java equivalents for each PL/SQL datatype). PL/SQL Datatype Java Equivalent VARCHAR2 java.lang.String DATE oracle.sql.DATE NUMBER (integer) int NUMBER (real) double ROWID java.lang.String OBJECT oracle.sql.STRUCT RAW byte[ ]
Q:
26-19.	The call spec for the OutputTest class is: CREATE OR REPLACE PROCEDURE output_test ...