Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!newsfeed.icl.net!opentransit.net!news.tele.dk!small.news.tele.dk!212.177.105.133!news.mailgate.org!web2news!203.200.15.20!not-for-mail From: "Shishir Mishra" Newsgroups: comp.databases.oracle.server Subject: Filtering data Date: Wed, 10 Oct 2001 07:36:59 +0000 (UTC) Organization: Mailgate.ORG Server - http://www.Mailgate.ORG Lines: 27 Message-ID: NNTP-Posting-Host: 203.200.15.20 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.mailgate.org 1002679366 14665 203.200.15.20 (Wed Oct 10 09:36:59 2001) X-Complaints-To: abuse@mailgate.org NNTP-Posting-Date: Wed, 10 Oct 2001 07:36:59 +0000 (UTC) Injector-Info: news.mailgate.org; posting-host=203.200.15.20; posting-account=32095; posting-date=1002679366 User-Agent: Mailgate Web Server X-URL: http://www.Mailgate.ORG Xref: easynews comp.databases.oracle.server:120766 X-Received-Date: Wed, 10 Oct 2001 03:54:35 MST (news.easynews.com) Hi Oracle Gods! I have stuck at one point . I am a Delphi programmar . My problem is: I Want to return a set of recordset from different table . I can do it using ref cursor . Now inside another function which will get above recordset , I want to filter the data (delete some unwanted record ) on basis of some condition . Then i am suppose to return these edited recordset to a diffrent function which will be also filter recordset and and again this function will return these to diffrent function . Though i can filter the recordset but the problem is that i have to access the so called table(data type) as array . I dont want to use that . I want to use sql statement to access that data. If i declare that table as object it still not working in the way which i want . So plz help me . thanx in advance shishir kumar mishra mail me at shishir@agnisoft.com -- Posted from [203.200.15.20] via Mailgate.ORG Server - http://www.Mailgate.ORG