Which statement is true about the command?

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?

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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


PIERO

PIERO

WHY B ? maybe cause absence of arguments ? please help me

Thomas Kyte

Thomas Kyte

Exactly

Leo Yu

Leo Yu

the “call specification”(wrapper method) pulishs the java class method, but would fail to execute because the NAME declaration lack formal java paramter