Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL question
Can any one tell me what I'm missing here? The following code causes the PL/SQL compiler (interpreter?) to complain that I have supplied an invalid table name. However, it appears as though the table name is valid when I examine the run-time variables.
Thanks,
Ben
declare
x varchar(255);
y varchar(255);
cursor c is
select datasrcname, updqueuename from vl_datasrc;
open c;
loop
fetch c into x,y; exit when c%NOTFOUND; execute immediate 'drop table :1' using x; execute immediate 'drop table :2' using y;end loop;