View the Exhibit to examine a Java source file.
You have the corresponding Java class file and you execute the command as follows:
SQL> CREATE OR REPLACE PROCEDURE ccformat
(x IN OUT VARCHAR2)
AS LANGUAGE JAVA
NAME ‘FormatCreditCardNo.formatCard()’;
Which statement is true about the command?
A.
It loads the Java class method into Oracle Database and publishes it.
B.
It publishes the Java class method, but the CCFORMAT PL/SQL procedure fails when it is
executed.
C.
It creates the CCFORMAT PL/SQL subprogram without publishing, which can be used to
invoke the Java class method.
D.
It publishes the Java class method and the CCFORMAT PL/SQL procedure invokes the Java
class method when it is executed.
B.
It’s not loaded.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_externproc.htm#i1006482
D
WHY B ? maybe cause absence of arguments ? please help me
Exactly
the “call specification”(wrapper method) pulishs the java class method, but would fail to execute because the NAME declaration lack formal java paramter