Stored Procedure Accelerator Guide for Oracle

9.9.2
- 9.9.3
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Variables as Arguments in a Procedure Call

You cannot declare a variable inside a PL/SQL block if you use the variable as an argument in a masked stored procedure or stored function.

For example, you want to mask the output of the following stored procedure:

dummy_proc_table2(
  in_int integer,
  o_int integer,
  o_table ddmtabletype) ; -- ddmtabletype is a TABLE Type defined at SCHEMA level

The following text is a stored procedure call that uses the declared variable v_int as an argument to the stored procedure:

Declare
  v_table ddmtabletype;
  v_int integer; -- declaration of variable
begin
  v_int := 12; -- value assigned
   dummy_proc_table2(
                    in_int => v_int, -- variable used  
                    o_int => :o_int,  
                    o_var => :o_var, 
                    v_table => v_table
                   );
end;

The request returns unmasked data.

The following text is a stored procedure that passes the value directly to the stored procedure call and returns masked data:

Declare
  v_table ddmtabletype;
begin
  dummy_proc_table2(
                    in_int => 12, 
                    o_int => :o_int,  
                    o_var => :o_var, 
                    v_table => v_table
                   );
end;

Rename Saved Search

Table of Contents

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

Variables as Arguments in a Procedure Call

Variables as Arguments in a Procedure Call