16.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 );
パラメータ
表16-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