Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

oracle search

Wednesday, August 6, 2008

Dynstatic SQL... ....oracle

Here's Connor again...

Note that the following code has been "anonymised" to protect the guilty.


procedure P is
begin
...
...
execute immediate 'drop table T';
execute immediate 'create table T as select * from ......';
...
...
...
for i in ( select * from T ) loop
...
...
end loop;
end;

Ah, a mix of dynamic and static references... Now how precisely did that compile? Nope, I'm not sure either.

No comments: