Re: Updates with sequences : not allowed ?

    Thanks,
  But i don't know much about dynamic SQL. Could someone give me an example or, best, the function i need ;) Bye

STolochkov_at_kkb.kz wrote:
>
> Hi!
> >
> > 1 create or replace function get_s
> > 2 (seq_name IN VARCHAR2(30))
> > 3 return number
> > 4 as
> > 5 l_s number;
> > 6 begin
> > 7 select seq_name.currval into l_s from dual;

 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


> >   8  return l_s

> >   9* end;

> >