No, you have it in the select twice.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Bosco Ng" <boscong_at_leccotech.com> wrote in message
news:3ebf9c01_at_shknews01...
> I have a sql statement that looks like this
>
> select
> a.c1,
> a.c2,
> b.c3,
> some_pkg.find_last_record(a.c1, b.c3)
> from a,
> b
> where a.id = b.id
> and some_pkg.find_last_record(a.c1, b.c3) is not null
>
>
> the some_pkg.find_last_record takes the 2 parameters to find the last
record
> that match them.
>
> The problem now is that when this sql fire, it will execute 2 times the
> some_pkg.find_last_record for 2 times, is there a way to only firing it
for
> 1 time?
>
>
> Thanks
>
>
Received on Mon May 12 2003 - 09:27:30 CDT
