Re: Filtering data

"Shishir Mishra" <shishir_at_agnisoft.com> wrote in message news:dbb1ff9aff315c3db8df54727be3cbb6.32095_at_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_at_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 Received on Wed Oct 10 2001 - 12:22:49 CDT