Change Increment index of for loop in stored procedure

[Gireesh Mulage]

HI All ,

To my stored procedure of Oracle i am passing a type , which contains some array of integers.
To fetch the values i am using for loop. The problem is the increment index is 1 . I want to change it to 2. How is it possible ?

Please help me on this.

[Rene Larsen]

You need to modify the stored procedure - and reload/recompile it in DB.

I don't know if you have the required access to do this - otherwise you need to talk to the DBA who has the access - or can give you the access.

[Gireesh Mulage]

Thank you Rene .

To solve my problem i have used IF MOD(i,2) = 0 function by keeping first value as 0.