Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes pl sql related problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "pl sql related problem" Watch "pl sql related problem" New topic

pl sql related problem

Ranveer K Kumar
Ranch Hand

Joined: Sep 13, 2009
Posts: 64
Hi all,

I am very new to PL SQL (just started to learn).
Facing problem in loop.
My requirement is to fetch first query using distinct. upon the result (cursor) I need to get the result for final out put.
more definition : in the distinct I am getting id and cid. total no of distinct result is 12, so I want to pass the value return by distinct query.
I think 12 time loop (count) will require. but I dont know how to execute this approach.

following is my code :

in above RET_DIST is geting 12 record count..
now from RET_DIST I want to pass language_id and article_id to LOOP (12 time) and LOOP should return a CURSOR..
Please help me. Also tell me if any better aproach for same problem..
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Try this (tested on 11g):
I agree. Here's the link:
subject: pl sql related problem
It's not a secret anymore!