Re: Pl/SQL Question

a function would be better here

create or replace function ds_func (seq_name in varchar2) return number as
seq_result number(38);
begin
execute immediate 'select '||seq_name||'.nextval from dual' into seq_result; return seq_result;
end;
/

Function created.

SQL> select test_func('dave_seq') from dual;

TEST_FUNC('DAVE_SEQ')

                   15

why you would want to do this is probably a better question

On 8/23/05, savitha malve <savithamalve_at_yahoo.com> wrote:

> I have been given a task to write a piece of pl/sql code/procedure which
> should accept a sequence name as IN parameter and output the nextval using
> OUT parameter. Any tips, ideas, suggestions will be very much apprectaited.

--
http://www.freelists.org/webpage/oracle-l