Re: Help:Pl/SQL Pass variable for sequence into SQL Select
From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/07/11
Message-ID: <5q4g9f$6rg$3_at_marri.bs.wa.gov.au>#1/1
Date: 1997/07/11
Message-ID: <5q4g9f$6rg$3_at_marri.bs.wa.gov.au>#1/1
Create a database function and 'register' all your sequences with it.
(Create a script for creating Oracle sequences which also maintains your
new database function)
To retrieve the sequence you want issue a select which looks something like
this -
select function_next_number(sequence_name) from dual;
PEMM
morris_gary_at_bah.com wrote in article <868469235.20569_at_dejanews.com>...
>I'm somewhat of a beginner trying to write a fairly simple sequence
>generator in PL/SQL. The user selects a client name and based on that
>client name it returns the next sequence for that client.
Received on Fri Jul 11 1997 - 00:00:00 CEST