Re: Dimension table load - PLSQL question

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