Re: execute immediate
From: Marc Billiet <first.last_at_hydro.com>
Date: Tue, 18 Dec 2001 13:43:20 GMT
Message-ID: <20011218.13432012_at_y1032696.hae.hydro.com>
Date: Tue, 18 Dec 2001 13:43:20 GMT
Message-ID: <20011218.13432012_at_y1032696.hae.hydro.com>
Op 2001-12-18, 13:47:41, schreef "andrija" <ar35644_at_fer.hr> over het the
ma
execute immediate:
> How can I store some value in variable with execute immediate? Somethi
ng
> like this:
> v date date;
> begin
> execute immediate 'select sysdate into :v date from dual';
> return v date;
> end;
declare
v date date;
begin
execute immediate 'select sysdate from dual' into v date;
dbms output.put line(v date);
end;
But of course you already found this in the manual ;-)
Marc Received on Tue Dec 18 2001 - 14:43:20 CET