Re: Simple PL/SQL question about sequences

N Prabhakar wrote:
>
> Jim Mc Ree <mcree_at_orionsci.com> wrote:
> >I want to implement a PL/SQL function where I pass in the name of a
> >sequence and get back the next value in the sequence.
>
> It can be implemented by using DBMS_SQL package by which you can
> substitute the input sequence name and retrieve the current value
>
> I am not sure about the syntax. My sincere apologies.
 

You can find the definition of package, 'DBMS_SQL' in the file "$ORACLE_HOME/rdbms/admin/dbmssql.sql" or similar file name.

Before you can use dynamic sql, be sure script 'dbmssql.sql' has been run once.
You should connect with 'sys' or 'internal' to run this script.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049