Re: Limit number of Rows in a table

From: Bhooshan S. Prabhu <bhooshan.prabhu_at_citicorp.com>
Date: Sat, 21 Jul 2001 21:25:49 GMT
Message-ID: <2cf4efe2.0107032232.6748abc8@posting.google.com>

Marco Wolfgarten <mwolfgarten_at_web.de> wrote in message news:<3b41d911$1_at_netnews.web.de>...
> Hi there!
>
>
> I'm trying to limit the number of rows in a table -> No INSERT must be possible.
> I tried to do this using a trigger, but I have no idea to forbid the
> transaction:
>
>
> create or replace trigger trg_limit_Customers before INSERT ON tbl_Customers
> declare
> numRows integer;
> begin
> SELECT Count(*) into numRows from tbl_Customers;
> if numRows>25 then
> ????? --Do not allow to insert more rows!
> end if;
> end;
>
>
> Does anybody know which command I have to use, or which other solution may fit
> this problem?
>
>
> Thanks for your help in advance!
>
>
> Marco

---

You can use RAISE_APPLICATION_ERROR with some error number and trap that error number in the block where you are actually inserting in the table.

Regards
Bhooshan Received on Sat Jul 21 2001 - 16:25:49 CDT