Stored Procedure/Trigger Performance question

Here is my scenario:

We are a small shop using Oracle 8i for development. We don't have anyone with professional DBA training and so our most senior programmer has taken this role. She is currently trying to setup triggers so that we can send an INSERT to a query with multiple tables and the trigger will handle all the proper INSERTs. She feels this is the best way for security purposes.

Now I've done some DBA work on MS-SQL Server before (not certified however) and from the System Administration course that I took for SQL Server 6.5, I was told that Stored Procedures are the best way to handle inserting data into multiple tables on a regular basis. I'm still new to Oracle so I don't want to step on any toes unless I have to.

My question is, which is faster? A single stored procedure to update the data, or a series of triggers? I have also been told that there are limitations to what triggers can access. Is this true as well?

Thank you,

Scott Pawluk
Programmer/Analyst
City of Winnipeg

PS-To reply directly, remove the nospam from my email address. Received on Mon May 14 2001 - 09:15:14 CDT