15.7 ADD_PARAMETER Procedure
This procedure adds a SQL parameter to the parameter collection. To use SQL parameters, prepare the array first, then use it in the execution call.
Syntax
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 );
Parameters
Table 15-5 ADD_PARAMETER Procedure Parameters
Parameter | Description |
---|---|
|
SQL parameter array. |
|
Parameter name. |
|
Parameter value. |
Example
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;
Parent topic: APEX_EXEC