execute immediate

How can I store some value in variable with execute immediate? Something like this:

v_date date;
begin

execute immediate 'select sysdate into :v_date from dual';

return v_date;
end;

Don't tell me that for this I dont need 'execute immediate', this is just an example. I don't need sysdate, I need to transfer value from execute immediate into a varible. Received on Tue Dec 18 2001 - 13:47:41 CET