which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

When setting arguments for a job, which procedure do you use for types that cannot be
implicitly converted to and from a VARCHAR2 datatype?

When setting arguments for a job, which procedure do you use for types that cannot be
implicitly converted to and from a VARCHAR2 datatype?

A.
SET_JOB_ARGUMENT_VALUE

B.
SET_JOB_VALUE_ANYDATA

C.
SET_JOB_ANYDATA_VALUE

D.
SET_SPECIAL_JOB_VALUE

E.
SET_JOB_ANYTYPE_VALUE

Show Hint

Leave a Reply 1

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

Jake from SF

Jake from SF

For C:

https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sched.htm#i1000820

SET_JOB_ANYDATA_VALUE Procedure
This procedure sets the value for an argument of the associated program for a job, encapsulated in an AnyData object. It overrides any default value set for the program argument. NULL is a valid assignment for a program argument. The argument can be specified by position or by name. You can specify by name only when:

The job points to a saved program object
The argument was assigned a name with the DEFINE_ANYDATA_ARGUMENT Procedure

Reply