15.7 ADD_PARAMETERプロシージャ
このプロシージャは、パラメータ・コレクションにSQLパラメータを追加します。SQLパラメータを使用するには、まず配列を準備し、次にそれを実行のコールで使用します。
構文
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in varchar2 );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in number );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in date );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in timestamp );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in timestamp with time zone );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in timestamp with local time zone );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in interval year to month );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in interval day to second );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in blob );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in bfile );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in clob );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_value in sys.anydata );
procedure add_parameter (
p_parameters in out nocopy t_parameters,
p_name in t_column_name,
p_data_type in t_data_type,
p_value in t_value );
パラメータ
表15-5 ADD_PARAMETERプロシージャのパラメータ
パラメータ | 説明 |
---|---|
|
SQLパラメータの配列。 |
|
パラメータ名。 |
|
パラメータ値 |
例
declare
l_parameters apex_exec.t_parameters;
begin
apex_exec.add_parameter( l_parameters, 'ENAME', 'SCOTT' );
apex_exec.add_parameter( l_parameters, 'SAL', 2000 );
apex_exec.add_parameter( l_parameters, 'HIREDATE', sysdate );
apex_exec.execute_remote_plsql(
p_server_static_id => '{static ID of the REST Enabled SQL Service}',
p_auto_bind_items => false,
p_plsql_code => q'#begin insert into emp values (:ENAME, :SAL, :HIREDATE ); end;#',
p_sql_parameters => l_parameters );
end;
親トピック: APEX_EXEC