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@(protected)> 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@(protected)> 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 >
This is what we are doing now ( in a little bit more convoluted fashion, but that's it ). <br><br> <div><span class="gmail_quote">On 9/29/05, <b class="gmail_sendername">Edgar Chupit</b> <<a href="mailto:chupit@(protected)">chupit@(protected)</a>> wrote :</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">Why not implement this in old fashioned way (don't you think that it<br>will work just fine), just do:<br> <br>begin<br>begin<br> select pkey into p_key from t where t.descr1 = ( select descr1<br>from lkp_table1 where cd = p_cd1 ) and t.descr2 = ( select descr2 from<br>lkp_table2 where cd = p_cd2 ) ...<br>exception when no_data _found then <br> insert into t values () returning pkey into p_key;<br>end;<br >return p_key;<br>end;<br><br>Don't you think that this is very simple and easy to understand method<br>to implement required functionality?<br><br>In dependable of the method that you will use, you still has to select <br>data from all the lpk_tableX and then check table t, it doesn't meter<br >whether you use simple select or other Oracle functionality.<br><br>On 9/29/05, Ranko Mosic <<a href="mailto:ranko.mosic@(protected)">ranko.mosic@(protected) </a>> wrote:<br>> Yes, thanks, that could be done. Still have problem with key value return if<br>> record exists.<br>> rm<br><br><br>--<br >Best regards,<br>Edgar Chupit<br><a href="callto://edgar.chupit">callto://edgar .chupit </a><br></blockquote></div><br>
