join on ROWID in EXECUTE IMMEDIATE

From: Per Haglund <per.haglund_at_visualwireless.com>
Date: 26 Jan 2004 02:24:29 -0800
Message-ID: <291d2c75.0401260224.763779eb@posting.google.com>

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

AND P3000_al_level.row_id(+) = P3000_.rowid

Row_id in "P3000_al_level" is a column with rowid datatype. In "P3000_" i use oracle rowid.
When I run the insertstatement in Toad it generate 0 inserts =correct. , when i run the statement using EXECUTE IMMEDIATE <string> in PL/SQL it generate 11 inserts (there are 11 rowids matching in p3000_al_level but with al_level=5).

/Per Received on Mon Jan 26 2004 - 04:24:29 CST