Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: join on ROWID in EXECUTE IMMEDIATE
Per Haglund wrote:
> My problem looks like this:
>
> I do an Insert based on joining two tables "P3000_" and
> "P3000_al_level"
> on ROWID, with this where condition:
>
> WHERE decode(P3000_al_level.al_id,null,2059, P3000_al_level.al_id) =
> 2059
> AND decode(P3000_al_level.al_level,null,99,P3000_al_level.al_level)
>
>>5
I can't help you with your specific question but you seem to be storing ROWID in a table. Do you understand that the ROWID of a table row is not a static value? The fact that you are pointing to it from stored data is no guarantee it will still have that same ROWID at some point in the future.
I may be misinterpreting what you wrote but your design looks fatally flawed to me.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Jan 26 2004 - 10:21:51 CST