At 01:44 PM 1/9/2003 +0530, Sivaraman Krishnan wrote:

>Hello Ann,
> I can use generators in my case for this billing.Because i have
>different types of billing and we are giving the provision for adding new
>billtype also.

OK, fine. You may discover that you're getting a lot of
deadlocks on this statement:

> UPDATE BILLTYPES SET NEXTBILLNUMBER = lpad((CAST(:NEXTBILL AS INTEGER)
>+ 1),'0',6)
> WHERE BILLTYPE = :BILLTYPE;

If so, and if that's a problem, there are other solutions,
including having a generator for each bill type.


Regards,

Ann
www.ibphoenix.com
We have answers.