|Subject||Re: [firebird-support] Can a "bad" stored procedure do low level file damage to an .fdb?|
|Author||Ann W. Harrison|
>I don't think so. You may be confusing stored procedures and UDF's.
> 1) An incorrectly written stored procedure can do low level file
> damage to a Firebird database file, corrupting it, and possibly making
> it unusable
> 2) Triggers, even incorrectly written, cannot do low level fileTriggers and stored procedures operate with most of the same
> damage. Yes, they may scramble your data, however, they will not
> corrupt the database file structure and ruin it.
>Then I think you're being overly cautious.
> Is this deduction true? I have been purposely avoiding using stored
> procedures because of this.
> Additionally, using stored procedures, inThere you'll get strong arguments on both sides, which I'm not going
> my opinion, is the "business rules" layer of a 3TCS system "leaking"
> into the "data storage" layer.