stored procedure notes

You're better off with stored procedures for (at least) the following reasons.

1. Stored procedures are compiled when created, and therefore run faster. A PL/SQL script has to be compiled each time it's run.
2. Stored procedures simplify privilege management, since stored procedures run in the security domain of the procedure's owner. You need only grant execute privileges on the procedure to users or a role, and all object access in the procedure is based on the privileges of the procedure owner. Typically the procedure owner is the same user that owns the objects accessed by the procedure.
3. Stored procedures are more portable. The PL/SQL scripts may be the same across operating systems, but the host script to run the procedures will differ. Stored procedures can also be imported and exported along with a user's other objects.

Hope this helps; just my $0.02. Received on Sat Sep 23 1995 - 00:00:00 CEST