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 JDBC and the fly likes pl sql related problem 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 » Databases » JDBC
Bookmark "pl sql related problem" Watch "pl sql related problem" New topic
Author

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):
 
 
subject: pl sql related problem
 
Similar Threads
Fetching Data from PL-SQL Table as OUT parameter in Java
Stored procedure which returns array
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Fetching Data from PL-SQL Table as OUT parameter in Java
Calling stored procedure problems