Redwood Documentation

Product Documentation

 

You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

›JCS Package

RunMyJobsPL/SQL API

Views

  • rs_all_registry_keys
  • rs_all_triggers
  • rs_applications
  • rs_credentials
  • rs_credential_users
  • rs_dba_jobs
  • rs_dba_job_parameters
  • rs_dba_role_privs
  • rs_dba_scripts
  • rs_destinations
  • rs_directories
  • rs_enabled_triggers
  • rs_events
  • rs_files
  • rs_formats
  • rs_format_upload_extensions
  • rs_index_types
  • rs_jobs
  • rs_job_definitions
  • rs_job_locks
  • rs_job_notes
  • rs_job_parameters
  • rs_job_statuses
  • rs_job_wait_events
  • rs_locks
  • rs_object_types
  • rs_operator_messages
  • rs_partitions
  • rs_protocols
  • rs_queues
  • rs_queue_schedulers
  • rs_registry_keys
  • rs_resources
  • rs_roles
  • rs_schedulers
  • rs_scheduler_file_events
  • rs_scheduler_parameters
  • rs_scheduler_queues
  • rs_scheduler_resources
  • rs_scripts
  • rs_scripttype_schedulers
  • rs_script_calls
  • rs_script_call_parameters
  • rs_script_locks
  • rs_script_parameters
  • rs_script_postconditions
  • rs_script_raise_events
  • rs_script_source
  • rs_script_stats
  • rs_script_steps
  • rs_script_step_postconditions
  • rs_script_wait_events
  • rs_submit_frames
  • rs_submit_frame_elements
  • rs_timezones
  • rs_time_windows
  • rs_time_window_elements
  • rs_users
  • rs_user_roles

JCS Package

  • Package jcs summary
  • jcs.add_job_lock
  • jcs.add_job_note
  • jcs.add_job_raise_event
  • jcs.add_job_wait_event
  • jcs.change_password
  • jcs.clear_event
  • jcs.clear_parameters
  • jcs.close
  • jcs.current_job
  • jcs.current_job_id
  • jcs.def_date
  • jcs.def_num
  • jcs.def_str
  • jcs.def_tstamp
  • jcs.delete_job
  • jcs.detach_child
  • jcs.disable_trigger
  • jcs.drop_user
  • jcs.enable_trigger
  • jcs.errorfile
  • jcs.explain_job_status
  • jcs.format_error_stack
  • jcs.generated_user
  • jcs.get_credential_password
  • jcs.get_current_user
  • jcs.get_date_timezone
  • jcs.get_default_partition
  • jcs.get_setuser
  • jcs.get_starttime
  • jcs.is_event_raised
  • jcs.job_parameter
  • jcs.job_pin_to_scheduler
  • jcs.job_status
  • jcs.job_statuscode
  • jcs.job_statuscode_wait
  • jcs.job_status_wait
  • jcs.last_job_id
  • jcs.multiple_values
  • jcs.no
  • jcs.open
  • jcs.operator_message
  • jcs.operator_reply
  • jcs.oracle_date_format
  • jcs.oracle_tstamp_format
  • jcs.outputfile
  • jcs.output_parameter
  • jcs.parameter
  • jcs.parent_job_id
  • jcs.raise_event
  • jcs.read
  • jcs.readfile
  • jcs.remove_job_wait_event
  • jcs.reschedule
  • jcs.return_code
  • jcs.run
  • jcs.search
  • jcs.searchfile
  • jcs.setchild
  • jcs.setpassword
  • jcs.setuser
  • jcs.set_current_job_status
  • jcs.set_date_timezone
  • jcs.set_default_partition
  • jcs.set_job_format
  • jcs.set_job_name
  • jcs.set_text_mode
  • jcs.submit
  • jcs.subscriber_info
  • jcs.ts_sort
  • jcs.use_known_password
  • jcs.wait
  • jcs.waitforone
  • jcs.yes

JCS_CHAIN Package

  • Package jcs_chain summary
  • jcs_chain.job_add_call

JCS_EVENT Package

  • Package jcs_event summary
  • jcs_event.event_comment
  • jcs_event.event_file
  • jcs_event.event_scheduler

JCS_ODF Package

  • Package jcs_odf summary
  • jcs_odf.alter_application
  • jcs_odf.alter_credential
  • jcs_odf.alter_event
  • jcs_odf.alter_format
  • jcs_odf.alter_lock
  • jcs_odf.alter_partition
  • jcs_odf.alter_queue
  • jcs_odf.alter_queue_scheduler
  • jcs_odf.alter_resource
  • jcs_odf.alter_scheduler
  • jcs_odf.alter_scheduler_file_event
  • jcs_odf.alter_scheduler_queue
  • jcs_odf.alter_script
  • jcs_odf.alter_submit_frame
  • jcs_odf.alter_time_window
  • jcs_odf.begin_transaction
  • jcs_odf.commit_transaction
  • jcs_odf.create_application
  • jcs_odf.create_credential
  • jcs_odf.create_event
  • jcs_odf.create_format
  • jcs_odf.create_lock
  • jcs_odf.create_partition
  • jcs_odf.create_queue
  • jcs_odf.create_queue_scheduler
  • jcs_odf.create_resource
  • jcs_odf.create_scheduler
  • jcs_odf.create_scheduler_file_event
  • jcs_odf.create_scheduler_queue
  • jcs_odf.create_scheduler_resource
  • jcs_odf.create_scheduler_scripttype
  • jcs_odf.create_script
  • jcs_odf.create_script_pcd
  • jcs_odf.create_script_step
  • jcs_odf.create_script_step_pcd
  • jcs_odf.create_submit_frame
  • jcs_odf.create_submit_frame_element
  • jcs_odf.create_time_window
  • jcs_odf.create_time_window_element
  • jcs_odf.ddl_trigger
  • jcs_odf.describe_into_table
  • jcs_odf.drop_application
  • jcs_odf.drop_credential
  • jcs_odf.drop_event
  • jcs_odf.drop_format
  • jcs_odf.drop_lock
  • jcs_odf.drop_monitor
  • jcs_odf.drop_partition
  • jcs_odf.drop_queue
  • jcs_odf.drop_queue_scheduler
  • jcs_odf.drop_resource
  • jcs_odf.drop_scheduler
  • jcs_odf.drop_scheduler_file_event
  • jcs_odf.drop_scheduler_queue
  • jcs_odf.drop_scheduler_resource
  • jcs_odf.drop_scheduler_scripttype
  • jcs_odf.drop_script
  • jcs_odf.drop_scripttype
  • jcs_odf.drop_submit_frame
  • jcs_odf.drop_submit_frame_element
  • jcs_odf.drop_time_window
  • jcs_odf.drop_time_window_element
  • jcs_odf.get_transaction_id
  • jcs_odf.rollback_transaction
  • jcs_odf.set_transaction_id

JCS_PRIV Package

  • Package jcs_priv summary
  • jcs_priv.delete_priv
  • jcs_priv.execute_priv
  • jcs_priv.insert_priv
  • jcs_priv.schema_application
  • jcs_priv.schema_code
  • jcs_priv.schema_credential
  • jcs_priv.schema_destination
  • jcs_priv.schema_directory
  • jcs_priv.schema_event
  • jcs_priv.schema_file
  • jcs_priv.schema_format
  • jcs_priv.schema_job
  • jcs_priv.schema_lock
  • jcs_priv.schema_monitor
  • jcs_priv.schema_partition
  • jcs_priv.schema_queue
  • jcs_priv.schema_registry
  • jcs_priv.schema_resource
  • jcs_priv.schema_scheduler
  • jcs_priv.schema_script
  • jcs_priv.schema_scripttype
  • jcs_priv.schema_submit_frame
  • jcs_priv.schema_time_window
  • jcs_priv.select_priv
  • jcs_priv.subscribe_priv
  • jcs_priv.update_priv

JCS_REGISTRY Package

  • Package jcs_registry summary
  • jcs_registry.check_key_id
  • jcs_registry.CURRENT_USER_PRF
  • jcs_registry.get_raw_key
  • jcs_registry.get_repos_parameter
  • jcs_registry.get_value
  • jcs_registry.key_path
  • jcs_registry.path_exists
  • jcs_registry.PUBLIC_PRF
  • jcs_registry.ROOT_CURRENT_USER
  • jcs_registry.ROOT_PUBLIC
  • jcs_registry.ROOT_USER

JCS_SNMP

  • Package jcs_snmp summary
  • jcs_snmp.generate_trap
  • jcs_snmp.sendtrap

TIME Package

  • Package time summary
  • time.calc_subfr
  • time.calc_win
  • time.timestamp_in_new_tz
← jcs.last_job_idjcs.no →

on-site-related topic PL/SQL API jcs.multiple_values

Summary

  • function multiple_values(p_001 in number, p_002 in number, p_003 in number, p_004 in number, p_005 in number, p_006 in number, p_007 in number, p_008 in number, p_009 in number, p_010 in number, p_011 in number, p_012 in number, p_013 in number, p_014 in number, p_015 in number, p_016 in number, p_017 in number, p_018 in number, p_019 in number, p_020 in number, p_021 in number, p_022 in number, p_023 in number, p_024 in number, p_025 in number, p_026 in number, p_027 in number, p_028 in number, p_029 in number, p_030 in number, p_031 in number, p_032 in number, p_033 in number, p_034 in number, p_035 in number, p_036 in number, p_037 in number, p_038 in number, p_039 in number, p_040 in number, p_041 in number, p_042 in number, p_043 in number, p_044 in number, p_045 in number, p_046 in number, p_047 in number, p_048 in number, p_049 in number, p_050 in number, p_051 in number, p_052 in number, p_053 in number, p_054 in number, p_055 in number, p_056 in number, p_057 in number, p_058 in number, p_059 in number, p_060 in number, p_061 in number, p_062 in number, p_063 in number, p_064 in number, p_065 in number, p_066 in number, p_067 in number, p_068 in number, p_069 in number, p_070 in number, p_071 in number, p_072 in number, p_073 in number, p_074 in number, p_075 in number, p_076 in number, p_077 in number, p_078 in number, p_079 in number, p_080 in number, p_081 in number, p_082 in number, p_083 in number, p_084 in number, p_085 in number, p_086 in number, p_087 in number, p_088 in number, p_089 in number, p_090 in number, p_091 in number, p_092 in number, p_093 in number, p_094 in number, p_095 in number, p_096 in number, p_097 in number, p_098 in number, p_099 in number, format in varchar2) return varchar2
  • function multiple_values(p_001 in date, p_002 in date, p_003 in date, p_004 in date, p_005 in date, p_006 in date, p_007 in date, p_008 in date, p_009 in date, p_010 in date, p_011 in date, p_012 in date, p_013 in date, p_014 in date, p_015 in date, p_016 in date, p_017 in date, p_018 in date, p_019 in date, p_020 in date, p_021 in date, p_022 in date, p_023 in date, p_024 in date, p_025 in date, p_026 in date, p_027 in date, p_028 in date, p_029 in date, p_030 in date, p_031 in date, p_032 in date, p_033 in date, p_034 in date, p_035 in date, p_036 in date, p_037 in date, p_038 in date, p_039 in date, p_040 in date, p_041 in date, p_042 in date, p_043 in date, p_044 in date, p_045 in date, p_046 in date, p_047 in date, p_048 in date, p_049 in date, p_050 in date, p_051 in date, p_052 in date, p_053 in date, p_054 in date, p_055 in date, p_056 in date, p_057 in date, p_058 in date, p_059 in date, p_060 in date, p_061 in date, p_062 in date, p_063 in date, p_064 in date, p_065 in date, p_066 in date, p_067 in date, p_068 in date, p_069 in date, p_070 in date, p_071 in date, p_072 in date, p_073 in date, p_074 in date, p_075 in date, p_076 in date, p_077 in date, p_078 in date, p_079 in date, p_080 in date, p_081 in date, p_082 in date, p_083 in date, p_084 in date, p_085 in date, p_086 in date, p_087 in date, p_088 in date, p_089 in date, p_090 in date, p_091 in date, p_092 in date, p_093 in date, p_094 in date, p_095 in date, p_096 in date, p_097 in date, p_098 in date, p_099 in date, format in varchar2) return varchar2
  • function multiple_values(p_001 in timestamp with time zone, p_002 in timestamp with time zone, p_003 in timestamp with time zone, p_004 in timestamp with time zone, p_005 in timestamp with time zone, p_006 in timestamp with time zone, p_007 in timestamp with time zone, p_008 in timestamp with time zone, p_009 in timestamp with time zone, p_010 in timestamp with time zone, p_011 in timestamp with time zone, p_012 in timestamp with time zone, p_013 in timestamp with time zone, p_014 in timestamp with time zone, p_015 in timestamp with time zone, p_016 in timestamp with time zone, p_017 in timestamp with time zone, p_018 in timestamp with time zone, p_019 in timestamp with time zone, p_020 in timestamp with time zone, p_021 in timestamp with time zone, p_022 in timestamp with time zone, p_023 in timestamp with time zone, p_024 in timestamp with time zone, p_025 in timestamp with time zone, p_026 in timestamp with time zone, p_027 in timestamp with time zone, p_028 in timestamp with time zone, p_029 in timestamp with time zone, p_030 in timestamp with time zone, p_031 in timestamp with time zone, p_032 in timestamp with time zone, p_033 in timestamp with time zone, p_034 in timestamp with time zone, p_035 in timestamp with time zone, p_036 in timestamp with time zone, p_037 in timestamp with time zone, p_038 in timestamp with time zone, p_039 in timestamp with time zone, p_040 in timestamp with time zone, p_041 in timestamp with time zone, p_042 in timestamp with time zone, p_043 in timestamp with time zone, p_044 in timestamp with time zone, p_045 in timestamp with time zone, p_046 in timestamp with time zone, p_047 in timestamp with time zone, p_048 in timestamp with time zone, p_049 in timestamp with time zone, p_050 in timestamp with time zone, p_051 in timestamp with time zone, p_052 in timestamp with time zone, p_053 in timestamp with time zone, p_054 in timestamp with time zone, p_055 in timestamp with time zone, p_056 in timestamp with time zone, p_057 in timestamp with time zone, p_058 in timestamp with time zone, p_059 in timestamp with time zone, p_060 in timestamp with time zone, p_061 in timestamp with time zone, p_062 in timestamp with time zone, p_063 in timestamp with time zone, p_064 in timestamp with time zone, p_065 in timestamp with time zone, p_066 in timestamp with time zone, p_067 in timestamp with time zone, p_068 in timestamp with time zone, p_069 in timestamp with time zone, p_070 in timestamp with time zone, p_071 in timestamp with time zone, p_072 in timestamp with time zone, p_073 in timestamp with time zone, p_074 in timestamp with time zone, p_075 in timestamp with time zone, p_076 in timestamp with time zone, p_077 in timestamp with time zone, p_078 in timestamp with time zone, p_079 in timestamp with time zone, p_080 in timestamp with time zone, p_081 in timestamp with time zone, p_082 in timestamp with time zone, p_083 in timestamp with time zone, p_084 in timestamp with time zone, p_085 in timestamp with time zone, p_086 in timestamp with time zone, p_087 in timestamp with time zone, p_088 in timestamp with time zone, p_089 in timestamp with time zone, p_090 in timestamp with time zone, p_091 in timestamp with time zone, p_092 in timestamp with time zone, p_093 in timestamp with time zone, p_094 in timestamp with time zone, p_095 in timestamp with time zone, p_096 in timestamp with time zone, p_097 in timestamp with time zone, p_098 in timestamp with time zone, p_099 in timestamp with time zone, format in varchar2) return varchar2
  • function multiple_values(p_001 in varchar2, p_002 in varchar2, p_003 in varchar2, p_004 in varchar2, p_005 in varchar2, p_006 in varchar2, p_007 in varchar2, p_008 in varchar2, p_009 in varchar2, p_010 in varchar2, p_011 in varchar2, p_012 in varchar2, p_013 in varchar2, p_014 in varchar2, p_015 in varchar2, p_016 in varchar2, p_017 in varchar2, p_018 in varchar2, p_019 in varchar2, p_020 in varchar2, p_021 in varchar2, p_022 in varchar2, p_023 in varchar2, p_024 in varchar2, p_025 in varchar2, p_026 in varchar2, p_027 in varchar2, p_028 in varchar2, p_029 in varchar2, p_030 in varchar2, p_031 in varchar2, p_032 in varchar2, p_033 in varchar2, p_034 in varchar2, p_035 in varchar2, p_036 in varchar2, p_037 in varchar2, p_038 in varchar2, p_039 in varchar2, p_040 in varchar2, p_041 in varchar2, p_042 in varchar2, p_043 in varchar2, p_044 in varchar2, p_045 in varchar2, p_046 in varchar2, p_047 in varchar2, p_048 in varchar2, p_049 in varchar2, p_050 in varchar2, p_051 in varchar2, p_052 in varchar2, p_053 in varchar2, p_054 in varchar2, p_055 in varchar2, p_056 in varchar2, p_057 in varchar2, p_058 in varchar2, p_059 in varchar2, p_060 in varchar2, p_061 in varchar2, p_062 in varchar2, p_063 in varchar2, p_064 in varchar2, p_065 in varchar2, p_066 in varchar2, p_067 in varchar2, p_068 in varchar2, p_069 in varchar2, p_070 in varchar2, p_071 in varchar2, p_072 in varchar2, p_073 in varchar2, p_074 in varchar2, p_075 in varchar2, p_076 in varchar2, p_077 in varchar2, p_078 in varchar2, p_079 in varchar2, p_080 in varchar2, p_081 in varchar2, p_082 in varchar2, p_083 in varchar2, p_084 in varchar2, p_085 in varchar2, p_086 in varchar2, p_087 in varchar2, p_088 in varchar2, p_089 in varchar2, p_090 in varchar2, p_091 in varchar2, p_092 in varchar2, p_093 in varchar2, p_094 in varchar2, p_095 in varchar2, p_096 in varchar2, p_097 in varchar2, p_098 in varchar2, p_099 in varchar2) return varchar2

Create an array of numbers in the internal representation.

You may create an empty array by specifying: jcs.multiple_values(''), this is used in default values for array parameters in job chains.

Specification

function multiple_values(p_001 in number,
p_002 in number default null,
p_003 in number default null,
p_004 in number default null,
p_005 in number default null,
p_006 in number default null,
p_007 in number default null,
p_008 in number default null,
p_009 in number default null,
p_010 in number default null,
p_011 in number default null,
p_012 in number default null,
p_013 in number default null,
p_014 in number default null,
p_015 in number default null,
p_016 in number default null,
p_017 in number default null,
p_018 in number default null,
p_019 in number default null,
p_020 in number default null,
p_021 in number default null,
p_022 in number default null,
p_023 in number default null,
p_024 in number default null,
p_025 in number default null,
p_026 in number default null,
p_027 in number default null,
p_028 in number default null,
p_029 in number default null,
p_030 in number default null,
p_031 in number default null,
p_032 in number default null,
p_033 in number default null,
p_034 in number default null,
p_035 in number default null,
p_036 in number default null,
p_037 in number default null,
p_038 in number default null,
p_039 in number default null,
p_040 in number default null,
p_041 in number default null,
p_042 in number default null,
p_043 in number default null,
p_044 in number default null,
p_045 in number default null,
p_046 in number default null,
p_047 in number default null,
p_048 in number default null,
p_049 in number default null,
p_050 in number default null,
p_051 in number default null,
p_052 in number default null,
p_053 in number default null,
p_054 in number default null,
p_055 in number default null,
p_056 in number default null,
p_057 in number default null,
p_058 in number default null,
p_059 in number default null,
p_060 in number default null,
p_061 in number default null,
p_062 in number default null,
p_063 in number default null,
p_064 in number default null,
p_065 in number default null,
p_066 in number default null,
p_067 in number default null,
p_068 in number default null,
p_069 in number default null,
p_070 in number default null,
p_071 in number default null,
p_072 in number default null,
p_073 in number default null,
p_074 in number default null,
p_075 in number default null,
p_076 in number default null,
p_077 in number default null,
p_078 in number default null,
p_079 in number default null,
p_080 in number default null,
p_081 in number default null,
p_082 in number default null,
p_083 in number default null,
p_084 in number default null,
p_085 in number default null,
p_086 in number default null,
p_087 in number default null,
p_088 in number default null,
p_089 in number default null,
p_090 in number default null,
p_091 in number default null,
p_092 in number default null,
p_093 in number default null,
p_094 in number default null,
p_095 in number default null,
p_096 in number default null,
p_097 in number default null,
p_098 in number default null,
p_099 in number default null,
format in varchar2 default null)
    return varchar2

Parameters

  • p_001 - Array value.
  • p_002 - Array value.
  • p_003 - Array value.
  • p_004 - Array value.
  • p_005 - Array value.
  • p_006 - Array value.
  • p_007 - Array value.
  • p_008 - Array value.
  • p_009 - Array value.
  • p_010 - Array value.
  • p_011 - Array value.
  • p_012 - Array value.
  • p_013 - Array value.
  • p_014 - Array value.
  • p_015 - Array value.
  • p_016 - Array value.
  • p_017 - Array value.
  • p_018 - Array value.
  • p_019 - Array value.
  • p_020 - Array value.
  • p_021 - Array value.
  • p_022 - Array value.
  • p_023 - Array value.
  • p_024 - Array value.
  • p_025 - Array value.
  • p_026 - Array value.
  • p_027 - Array value.
  • p_028 - Array value.
  • p_029 - Array value.
  • p_030 - Array value.
  • p_031 - Array value.
  • p_032 - Array value.
  • p_033 - Array value.
  • p_034 - Array value.
  • p_035 - Array value.
  • p_036 - Array value.
  • p_037 - Array value.
  • p_038 - Array value.
  • p_039 - Array value.
  • p_040 - Array value.
  • p_041 - Array value.
  • p_042 - Array value.
  • p_043 - Array value.
  • p_044 - Array value.
  • p_045 - Array value.
  • p_046 - Array value.
  • p_047 - Array value.
  • p_048 - Array value.
  • p_049 - Array value.
  • p_050 - Array value.
  • p_051 - Array value.
  • p_052 - Array value.
  • p_053 - Array value.
  • p_054 - Array value.
  • p_055 - Array value.
  • p_056 - Array value.
  • p_057 - Array value.
  • p_058 - Array value.
  • p_059 - Array value.
  • p_060 - Array value.
  • p_061 - Array value.
  • p_062 - Array value.
  • p_063 - Array value.
  • p_064 - Array value.
  • p_065 - Array value.
  • p_066 - Array value.
  • p_067 - Array value.
  • p_068 - Array value.
  • p_069 - Array value.
  • p_070 - Array value.
  • p_071 - Array value.
  • p_072 - Array value.
  • p_073 - Array value.
  • p_074 - Array value.
  • p_075 - Array value.
  • p_076 - Array value.
  • p_077 - Array value.
  • p_078 - Array value.
  • p_079 - Array value.
  • p_080 - Array value.
  • p_081 - Array value.
  • p_082 - Array value.
  • p_083 - Array value.
  • p_084 - Array value.
  • p_085 - Array value.
  • p_086 - Array value.
  • p_087 - Array value.
  • p_088 - Array value.
  • p_089 - Array value.
  • p_090 - Array value.
  • p_091 - Array value.
  • p_092 - Array value.
  • p_093 - Array value.
  • p_094 - Array value.
  • p_095 - Array value.
  • p_096 - Array value.
  • p_097 - Array value.
  • p_098 - Array value.
  • p_099 - Array value.
  • format - Array value.
  • returns varchar2 - an array of numbers in the internal representation,

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Specification

function multiple_values(p_001 in date,
p_002 in date default null,
p_003 in date default null,
p_004 in date default null,
p_005 in date default null,
p_006 in date default null,
p_007 in date default null,
p_008 in date default null,
p_009 in date default null,
p_010 in date default null,
p_011 in date default null,
p_012 in date default null,
p_013 in date default null,
p_014 in date default null,
p_015 in date default null,
p_016 in date default null,
p_017 in date default null,
p_018 in date default null,
p_019 in date default null,
p_020 in date default null,
p_021 in date default null,
p_022 in date default null,
p_023 in date default null,
p_024 in date default null,
p_025 in date default null,
p_026 in date default null,
p_027 in date default null,
p_028 in date default null,
p_029 in date default null,
p_030 in date default null,
p_031 in date default null,
p_032 in date default null,
p_033 in date default null,
p_034 in date default null,
p_035 in date default null,
p_036 in date default null,
p_037 in date default null,
p_038 in date default null,
p_039 in date default null,
p_040 in date default null,
p_041 in date default null,
p_042 in date default null,
p_043 in date default null,
p_044 in date default null,
p_045 in date default null,
p_046 in date default null,
p_047 in date default null,
p_048 in date default null,
p_049 in date default null,
p_050 in date default null,
p_051 in date default null,
p_052 in date default null,
p_053 in date default null,
p_054 in date default null,
p_055 in date default null,
p_056 in date default null,
p_057 in date default null,
p_058 in date default null,
p_059 in date default null,
p_060 in date default null,
p_061 in date default null,
p_062 in date default null,
p_063 in date default null,
p_064 in date default null,
p_065 in date default null,
p_066 in date default null,
p_067 in date default null,
p_068 in date default null,
p_069 in date default null,
p_070 in date default null,
p_071 in date default null,
p_072 in date default null,
p_073 in date default null,
p_074 in date default null,
p_075 in date default null,
p_076 in date default null,
p_077 in date default null,
p_078 in date default null,
p_079 in date default null,
p_080 in date default null,
p_081 in date default null,
p_082 in date default null,
p_083 in date default null,
p_084 in date default null,
p_085 in date default null,
p_086 in date default null,
p_087 in date default null,
p_088 in date default null,
p_089 in date default null,
p_090 in date default null,
p_091 in date default null,
p_092 in date default null,
p_093 in date default null,
p_094 in date default null,
p_095 in date default null,
p_096 in date default null,
p_097 in date default null,
p_098 in date default null,
p_099 in date default null,
format in varchar2 default null)
    return varchar2

Parameters

  • p_001 - Array value.
  • p_002 - Array value.
  • p_003 - Array value.
  • p_004 - Array value.
  • p_005 - Array value.
  • p_006 - Array value.
  • p_007 - Array value.
  • p_008 - Array value.
  • p_009 - Array value.
  • p_010 - Array value.
  • p_011 - Array value.
  • p_012 - Array value.
  • p_013 - Array value.
  • p_014 - Array value.
  • p_015 - Array value.
  • p_016 - Array value.
  • p_017 - Array value.
  • p_018 - Array value.
  • p_019 - Array value.
  • p_020 - Array value.
  • p_021 - Array value.
  • p_022 - Array value.
  • p_023 - Array value.
  • p_024 - Array value.
  • p_025 - Array value.
  • p_026 - Array value.
  • p_027 - Array value.
  • p_028 - Array value.
  • p_029 - Array value.
  • p_030 - Array value.
  • p_031 - Array value.
  • p_032 - Array value.
  • p_033 - Array value.
  • p_034 - Array value.
  • p_035 - Array value.
  • p_036 - Array value.
  • p_037 - Array value.
  • p_038 - Array value.
  • p_039 - Array value.
  • p_040 - Array value.
  • p_041 - Array value.
  • p_042 - Array value.
  • p_043 - Array value.
  • p_044 - Array value.
  • p_045 - Array value.
  • p_046 - Array value.
  • p_047 - Array value.
  • p_048 - Array value.
  • p_049 - Array value.
  • p_050 - Array value.
  • p_051 - Array value.
  • p_052 - Array value.
  • p_053 - Array value.
  • p_054 - Array value.
  • p_055 - Array value.
  • p_056 - Array value.
  • p_057 - Array value.
  • p_058 - Array value.
  • p_059 - Array value.
  • p_060 - Array value.
  • p_061 - Array value.
  • p_062 - Array value.
  • p_063 - Array value.
  • p_064 - Array value.
  • p_065 - Array value.
  • p_066 - Array value.
  • p_067 - Array value.
  • p_068 - Array value.
  • p_069 - Array value.
  • p_070 - Array value.
  • p_071 - Array value.
  • p_072 - Array value.
  • p_073 - Array value.
  • p_074 - Array value.
  • p_075 - Array value.
  • p_076 - Array value.
  • p_077 - Array value.
  • p_078 - Array value.
  • p_079 - Array value.
  • p_080 - Array value.
  • p_081 - Array value.
  • p_082 - Array value.
  • p_083 - Array value.
  • p_084 - Array value.
  • p_085 - Array value.
  • p_086 - Array value.
  • p_087 - Array value.
  • p_088 - Array value.
  • p_089 - Array value.
  • p_090 - Array value.
  • p_091 - Array value.
  • p_092 - Array value.
  • p_093 - Array value.
  • p_094 - Array value.
  • p_095 - Array value.
  • p_096 - Array value.
  • p_097 - Array value.
  • p_098 - Array value.
  • p_099 - Array value.
  • format - Array value.
  • returns varchar2 - an array of dates in the internal representation,

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Specification

function multiple_values(p_001 in timestamp with time zone,
p_002 in timestamp with time zone default null,
p_003 in timestamp with time zone default null,
p_004 in timestamp with time zone default null,
p_005 in timestamp with time zone default null,
p_006 in timestamp with time zone default null,
p_007 in timestamp with time zone default null,
p_008 in timestamp with time zone default null,
p_009 in timestamp with time zone default null,
p_010 in timestamp with time zone default null,
p_011 in timestamp with time zone default null,
p_012 in timestamp with time zone default null,
p_013 in timestamp with time zone default null,
p_014 in timestamp with time zone default null,
p_015 in timestamp with time zone default null,
p_016 in timestamp with time zone default null,
p_017 in timestamp with time zone default null,
p_018 in timestamp with time zone default null,
p_019 in timestamp with time zone default null,
p_020 in timestamp with time zone default null,
p_021 in timestamp with time zone default null,
p_022 in timestamp with time zone default null,
p_023 in timestamp with time zone default null,
p_024 in timestamp with time zone default null,
p_025 in timestamp with time zone default null,
p_026 in timestamp with time zone default null,
p_027 in timestamp with time zone default null,
p_028 in timestamp with time zone default null,
p_029 in timestamp with time zone default null,
p_030 in timestamp with time zone default null,
p_031 in timestamp with time zone default null,
p_032 in timestamp with time zone default null,
p_033 in timestamp with time zone default null,
p_034 in timestamp with time zone default null,
p_035 in timestamp with time zone default null,
p_036 in timestamp with time zone default null,
p_037 in timestamp with time zone default null,
p_038 in timestamp with time zone default null,
p_039 in timestamp with time zone default null,
p_040 in timestamp with time zone default null,
p_041 in timestamp with time zone default null,
p_042 in timestamp with time zone default null,
p_043 in timestamp with time zone default null,
p_044 in timestamp with time zone default null,
p_045 in timestamp with time zone default null,
p_046 in timestamp with time zone default null,
p_047 in timestamp with time zone default null,
p_048 in timestamp with time zone default null,
p_049 in timestamp with time zone default null,
p_050 in timestamp with time zone default null,
p_051 in timestamp with time zone default null,
p_052 in timestamp with time zone default null,
p_053 in timestamp with time zone default null,
p_054 in timestamp with time zone default null,
p_055 in timestamp with time zone default null,
p_056 in timestamp with time zone default null,
p_057 in timestamp with time zone default null,
p_058 in timestamp with time zone default null,
p_059 in timestamp with time zone default null,
p_060 in timestamp with time zone default null,
p_061 in timestamp with time zone default null,
p_062 in timestamp with time zone default null,
p_063 in timestamp with time zone default null,
p_064 in timestamp with time zone default null,
p_065 in timestamp with time zone default null,
p_066 in timestamp with time zone default null,
p_067 in timestamp with time zone default null,
p_068 in timestamp with time zone default null,
p_069 in timestamp with time zone default null,
p_070 in timestamp with time zone default null,
p_071 in timestamp with time zone default null,
p_072 in timestamp with time zone default null,
p_073 in timestamp with time zone default null,
p_074 in timestamp with time zone default null,
p_075 in timestamp with time zone default null,
p_076 in timestamp with time zone default null,
p_077 in timestamp with time zone default null,
p_078 in timestamp with time zone default null,
p_079 in timestamp with time zone default null,
p_080 in timestamp with time zone default null,
p_081 in timestamp with time zone default null,
p_082 in timestamp with time zone default null,
p_083 in timestamp with time zone default null,
p_084 in timestamp with time zone default null,
p_085 in timestamp with time zone default null,
p_086 in timestamp with time zone default null,
p_087 in timestamp with time zone default null,
p_088 in timestamp with time zone default null,
p_089 in timestamp with time zone default null,
p_090 in timestamp with time zone default null,
p_091 in timestamp with time zone default null,
p_092 in timestamp with time zone default null,
p_093 in timestamp with time zone default null,
p_094 in timestamp with time zone default null,
p_095 in timestamp with time zone default null,
p_096 in timestamp with time zone default null,
p_097 in timestamp with time zone default null,
p_098 in timestamp with time zone default null,
p_099 in timestamp with time zone default null,
format in varchar2 default null)
    return varchar2

Parameters

  • p_001 - Array value.
  • p_002 - Array value.
  • p_003 - Array value.
  • p_004 - Array value.
  • p_005 - Array value.
  • p_006 - Array value.
  • p_007 - Array value.
  • p_008 - Array value.
  • p_009 - Array value.
  • p_010 - Array value.
  • p_011 - Array value.
  • p_012 - Array value.
  • p_013 - Array value.
  • p_014 - Array value.
  • p_015 - Array value.
  • p_016 - Array value.
  • p_017 - Array value.
  • p_018 - Array value.
  • p_019 - Array value.
  • p_020 - Array value.
  • p_021 - Array value.
  • p_022 - Array value.
  • p_023 - Array value.
  • p_024 - Array value.
  • p_025 - Array value.
  • p_026 - Array value.
  • p_027 - Array value.
  • p_028 - Array value.
  • p_029 - Array value.
  • p_030 - Array value.
  • p_031 - Array value.
  • p_032 - Array value.
  • p_033 - Array value.
  • p_034 - Array value.
  • p_035 - Array value.
  • p_036 - Array value.
  • p_037 - Array value.
  • p_038 - Array value.
  • p_039 - Array value.
  • p_040 - Array value.
  • p_041 - Array value.
  • p_042 - Array value.
  • p_043 - Array value.
  • p_044 - Array value.
  • p_045 - Array value.
  • p_046 - Array value.
  • p_047 - Array value.
  • p_048 - Array value.
  • p_049 - Array value.
  • p_050 - Array value.
  • p_051 - Array value.
  • p_052 - Array value.
  • p_053 - Array value.
  • p_054 - Array value.
  • p_055 - Array value.
  • p_056 - Array value.
  • p_057 - Array value.
  • p_058 - Array value.
  • p_059 - Array value.
  • p_060 - Array value.
  • p_061 - Array value.
  • p_062 - Array value.
  • p_063 - Array value.
  • p_064 - Array value.
  • p_065 - Array value.
  • p_066 - Array value.
  • p_067 - Array value.
  • p_068 - Array value.
  • p_069 - Array value.
  • p_070 - Array value.
  • p_071 - Array value.
  • p_072 - Array value.
  • p_073 - Array value.
  • p_074 - Array value.
  • p_075 - Array value.
  • p_076 - Array value.
  • p_077 - Array value.
  • p_078 - Array value.
  • p_079 - Array value.
  • p_080 - Array value.
  • p_081 - Array value.
  • p_082 - Array value.
  • p_083 - Array value.
  • p_084 - Array value.
  • p_085 - Array value.
  • p_086 - Array value.
  • p_087 - Array value.
  • p_088 - Array value.
  • p_089 - Array value.
  • p_090 - Array value.
  • p_091 - Array value.
  • p_092 - Array value.
  • p_093 - Array value.
  • p_094 - Array value.
  • p_095 - Array value.
  • p_096 - Array value.
  • p_097 - Array value.
  • p_098 - Array value.
  • p_099 - Array value.
  • format - Array value.
  • returns varchar2 - an array of timestamps in the internal representation,

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Specification

function multiple_values(p_001 in varchar2 default null,
p_002 in varchar2 default null,
p_003 in varchar2 default null,
p_004 in varchar2 default null,
p_005 in varchar2 default null,
p_006 in varchar2 default null,
p_007 in varchar2 default null,
p_008 in varchar2 default null,
p_009 in varchar2 default null,
p_010 in varchar2 default null,
p_011 in varchar2 default null,
p_012 in varchar2 default null,
p_013 in varchar2 default null,
p_014 in varchar2 default null,
p_015 in varchar2 default null,
p_016 in varchar2 default null,
p_017 in varchar2 default null,
p_018 in varchar2 default null,
p_019 in varchar2 default null,
p_020 in varchar2 default null,
p_021 in varchar2 default null,
p_022 in varchar2 default null,
p_023 in varchar2 default null,
p_024 in varchar2 default null,
p_025 in varchar2 default null,
p_026 in varchar2 default null,
p_027 in varchar2 default null,
p_028 in varchar2 default null,
p_029 in varchar2 default null,
p_030 in varchar2 default null,
p_031 in varchar2 default null,
p_032 in varchar2 default null,
p_033 in varchar2 default null,
p_034 in varchar2 default null,
p_035 in varchar2 default null,
p_036 in varchar2 default null,
p_037 in varchar2 default null,
p_038 in varchar2 default null,
p_039 in varchar2 default null,
p_040 in varchar2 default null,
p_041 in varchar2 default null,
p_042 in varchar2 default null,
p_043 in varchar2 default null,
p_044 in varchar2 default null,
p_045 in varchar2 default null,
p_046 in varchar2 default null,
p_047 in varchar2 default null,
p_048 in varchar2 default null,
p_049 in varchar2 default null,
p_050 in varchar2 default null,
p_051 in varchar2 default null,
p_052 in varchar2 default null,
p_053 in varchar2 default null,
p_054 in varchar2 default null,
p_055 in varchar2 default null,
p_056 in varchar2 default null,
p_057 in varchar2 default null,
p_058 in varchar2 default null,
p_059 in varchar2 default null,
p_060 in varchar2 default null,
p_061 in varchar2 default null,
p_062 in varchar2 default null,
p_063 in varchar2 default null,
p_064 in varchar2 default null,
p_065 in varchar2 default null,
p_066 in varchar2 default null,
p_067 in varchar2 default null,
p_068 in varchar2 default null,
p_069 in varchar2 default null,
p_070 in varchar2 default null,
p_071 in varchar2 default null,
p_072 in varchar2 default null,
p_073 in varchar2 default null,
p_074 in varchar2 default null,
p_075 in varchar2 default null,
p_076 in varchar2 default null,
p_077 in varchar2 default null,
p_078 in varchar2 default null,
p_079 in varchar2 default null,
p_080 in varchar2 default null,
p_081 in varchar2 default null,
p_082 in varchar2 default null,
p_083 in varchar2 default null,
p_084 in varchar2 default null,
p_085 in varchar2 default null,
p_086 in varchar2 default null,
p_087 in varchar2 default null,
p_088 in varchar2 default null,
p_089 in varchar2 default null,
p_090 in varchar2 default null,
p_091 in varchar2 default null,
p_092 in varchar2 default null,
p_093 in varchar2 default null,
p_094 in varchar2 default null,
p_095 in varchar2 default null,
p_096 in varchar2 default null,
p_097 in varchar2 default null,
p_098 in varchar2 default null,
p_099 in varchar2 default null)
    return varchar2

Parameters

  • p_001 - Array value.
  • p_002 - Array value.
  • p_003 - Array value.
  • p_004 - Array value.
  • p_005 - Array value.
  • p_006 - Array value.
  • p_007 - Array value.
  • p_008 - Array value.
  • p_009 - Array value.
  • p_010 - Array value.
  • p_011 - Array value.
  • p_012 - Array value.
  • p_013 - Array value.
  • p_014 - Array value.
  • p_015 - Array value.
  • p_016 - Array value.
  • p_017 - Array value.
  • p_018 - Array value.
  • p_019 - Array value.
  • p_020 - Array value.
  • p_021 - Array value.
  • p_022 - Array value.
  • p_023 - Array value.
  • p_024 - Array value.
  • p_025 - Array value.
  • p_026 - Array value.
  • p_027 - Array value.
  • p_028 - Array value.
  • p_029 - Array value.
  • p_030 - Array value.
  • p_031 - Array value.
  • p_032 - Array value.
  • p_033 - Array value.
  • p_034 - Array value.
  • p_035 - Array value.
  • p_036 - Array value.
  • p_037 - Array value.
  • p_038 - Array value.
  • p_039 - Array value.
  • p_040 - Array value.
  • p_041 - Array value.
  • p_042 - Array value.
  • p_043 - Array value.
  • p_044 - Array value.
  • p_045 - Array value.
  • p_046 - Array value.
  • p_047 - Array value.
  • p_048 - Array value.
  • p_049 - Array value.
  • p_050 - Array value.
  • p_051 - Array value.
  • p_052 - Array value.
  • p_053 - Array value.
  • p_054 - Array value.
  • p_055 - Array value.
  • p_056 - Array value.
  • p_057 - Array value.
  • p_058 - Array value.
  • p_059 - Array value.
  • p_060 - Array value.
  • p_061 - Array value.
  • p_062 - Array value.
  • p_063 - Array value.
  • p_064 - Array value.
  • p_065 - Array value.
  • p_066 - Array value.
  • p_067 - Array value.
  • p_068 - Array value.
  • p_069 - Array value.
  • p_070 - Array value.
  • p_071 - Array value.
  • p_072 - Array value.
  • p_073 - Array value.
  • p_074 - Array value.
  • p_075 - Array value.
  • p_076 - Array value.
  • p_077 - Array value.
  • p_078 - Array value.
  • p_079 - Array value.
  • p_080 - Array value.
  • p_081 - Array value.
  • p_082 - Array value.
  • p_083 - Array value.
  • p_084 - Array value.
  • p_085 - Array value.
  • p_086 - Array value.
  • p_087 - Array value.
  • p_088 - Array value.
  • p_089 - Array value.
  • p_090 - Array value.
  • p_091 - Array value.
  • p_092 - Array value.
  • p_093 - Array value.
  • p_094 - Array value.
  • p_095 - Array value.
  • p_096 - Array value.
  • p_097 - Array value.
  • p_098 - Array value.
  • p_099 - Array value.
  • returns varchar2 - an array of strings in the internal representation,

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

plsqlTopic

onsiteTopic

← jcs.last_job_idjcs.no →
  • Summary
  • Specification
  • Parameters
  • Transaction keyword
  • Specification
  • Parameters
  • Transaction keyword
  • Specification
  • Parameters
  • Transaction keyword
  • Specification
  • Parameters
  • Transaction keyword
Docs
Getting StartedInstallationFinance InstallationConcepts
TroubleshootingArchiving
Learn and Connect
Support Portal
BlogEventsResources
ISO/ IEC 27001 Information Security Management
Automate to be human

2023 All Rights Reserved |

Terms of Service | Policies | Cookies | Glossary | Third-party Software | Contact | Copyright | Impressum |