Redwood Documentation

Product Documentation

 

›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 |