This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Change Increment index of for loop in stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Change Increment index of for loop in stored procedure" Watch "Change Increment index of for loop in stored procedure" New topic
Author

Change Increment index of for loop in stored procedure

Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
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

Joined: Oct 12, 2001
Posts: 1179

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.


Regards, Rene Larsen
Dropbox Invite
Gireesh Mulage
Ranch Hand

Joined: Mar 08, 2010
Posts: 44
Thank you Rene .

To solve my problem i have used IF MOD(i,2) = 0 function by keeping first value as 0.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Change Increment index of for loop in stored procedure
 
Similar Threads
with Java: how to update a row in sybase with string having a single quote
java and jdbc
Change Increment index of for loop in stored procedure
java and jdbc
Change in forum