Table of Contents

Search

  1. Preface
  2. Introduction to the Stored Procedure Accelerator for Oracle
  3. Masking Stored Procedures and User-Defined Table Functions
  4. Stored Procedure Accelerator Setup
  5. Stored Procedure Accelerator Rules

Stored Procedure Accelerator Guide for Oracle

Stored Procedure Accelerator Guide for Oracle

Positional and Named Parameters

Positional and Named Parameters

You cannot use both positional and named parameters in the same stored procedure call.
Stored procedure calls can contain positional parameters or named parameters, but cannot have mixed case.
For example, the following text is a call that contains named parameters:
call dummy_proc_1(v_int=>'123', v_var=>?, v_ref=>?)
The following text is a call that contains positional parameters:
call dummy_proc_1(?,?,?)
The calls with named and positional parameters are masked. However, the following call is not masked because it contains a mix of named and positional parameters:
call oracle_1out_sys_1rs_2constip(?,eid => 1000,ename => 'kannan')

0 COMMENTS

We’d like to hear from you!