このプロシージャは、パラメータ・コレクションに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 );
パラメータ
表13-4 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