dynamic sql in PL/SQL block
From: Martin Trieu <mtrieu_at_mdcsc>
Date: Fri, 11 Mar 1994 00:56:26 GMT
Message-ID: <CMH6M3.4J7_at_mdis.co.uk>
Date: Fri, 11 Mar 1994 00:56:26 GMT
Message-ID: <CMH6M3.4J7_at_mdis.co.uk>
Does anyone know why ORACLE does not support dynamic sql in PL/SQL block?
For example:
declare
sql varchar2(200);
begin
sql:='create table x (i number)';
run_dynamic_sql(sql);
end;
thanks,
Martin
Received on Fri Mar 11 1994 - 01:56:26 CET