File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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