Path: news.easynews.com!easynews!sjc-peer.news.verio.net!news.verio.net!sn-xit-01!sn-post-01!supernews.com!news.demon.nl!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: Filtering data Date: Wed, 10 Oct 2001 19:22:49 +0200 Message-ID: Reply-To: "Sybrand Bakker" References: X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: news.demon.nl 1002735522 news:10165 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 57 Xref: easynews comp.databases.oracle.server:120844 X-Received-Date: Wed, 10 Oct 2001 10:39:44 MST (news.easynews.com) "Shishir Mishra" wrote in message news:dbb1ff9aff315c3db8df54727be3cbb6.32095@mygate.mailgate.org... > > 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 One of the first commandments in using Oracle is you should do *everything* on the database side what you *can* do on the database side. Filtering records in a procedure is a *very bad* idea, and from what you describe I don't hope I ever have to look at your actual code. You're asking the impossible. Restructure your code and try to do as much as possible in *one* sqlstatement instead of at procedural level. Regards, Sybrand Bakker Senior Oracle DBA