Function new_key (inout number)
is
keyval number;
begin
select sequencename.nextval into keyval from dual;
return keyval;
end;

or something similar, as part of a package, call it with sqlexec with
sqlexec(schema.package.function(parameter))

The inout should make it work,as the paramete goes both ways then.