Intermediate
Q: | |||||||||||||||||
26-12. | These steps for accessing a Java class from PL/SQL are now in order:
| ||||||||||||||||
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).
| ||||||||||||||||
Q: | |||||||||||||||||
26-19. | The call spec for the OutputTest class is: CREATE OR REPLACE PROCEDURE output_test ... |
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.