Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Change Increment index of for loop in stored procedure

 
Gireesh Mulage
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Rene .

To solve my problem i have used IF MOD(i,2) = 0 function by keeping first value as 0.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic