This is what we are doing now ( in a little bit more convoluted fashion, but
that's it ).
On 9/29/05, Edgar Chupit <chupit_at_gmail.com> wrote:
>
> Why not implement this in old fashioned way (don't you think that it
> will work just fine), just do:
>
> begin
> begin
> select pkey into p_key from t where t.descr1 = ( select descr1
> from lkp_table1 where cd = p_cd1 ) and t.descr2 = ( select descr2 from
> lkp_table2 where cd = p_cd2 ) ...
> exception when no_data_found then
> insert into t values () returning pkey into p_key;
> end;
> return p_key;
> end;
>
> Don't you think that this is very simple and easy to understand method
> to implement required functionality?
>
> In dependable of the method that you will use, you still has to select
> data from all the lpk_tableX and then check table t, it doesn't meter
> whether you use simple select or other Oracle functionality.
>
> On 9/29/05, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> > Yes, thanks, that could be done. Still have problem with key value
> return if
> > record exists.
> > rm
>
>
> --
> Best regards,
> Edgar Chupit
> callto://edgar.chupit
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 29 2005 - 14:51:33 CDT
