Re: "We don't do triggers"

(Pete Cresswell) wrote:

> RE/
>

>>An Oracle database
>>with more than a handful of procedures should have no procedures:
>>It should have packages.

Then it is time you learned, eh.

A package is a collection, a library if you will, containing one or more   procedures and functions. It can contain an initialization section, it can be used to defined constants, variables, user defined data types, user defined exceptions, REF CURSORS, and can be overloaded.

And since you'll not know all these things you can not go to http://tahiti.oracle.com and look them up.

Lets get started ... lets find out what's in that schema:

SELECT object_type, COUNT(*)
FROM user_objects
GROUP BY object_type;

Now you know whats there and what isn't.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)