Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "We don't do triggers"

Re: "We don't do triggers"

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 22 Nov 2003 14:00:44 -0800
Message-ID: <1069538472.685916@yasure>


(Pete Cresswell) wrote:

> RE/
>

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

>
>
> I'm probably giving them a bad rap then - I don't know enough to distinguish
> between SPs and packages....my role is just as an SME - having written the
> application that this one is to replace.

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)
Received on Sat Nov 22 2003 - 16:00:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US