RE: RE: Wrapping trigger code

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 12 Jan 2005 14:18:49 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E722@usahm236.amer.corp.eds.com>

Mccdba, Note "obfuscated" <> "obsoleted". 10g supports the create function etc... statements. The note below tells you what objects can be wrapped.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc Sent: Wednesday, January 12, 2005 1:57 PM To: oracle-l_at_freelists.org
Subject: Fwd: RE: Wrapping trigger code

I wonder "create function", "create procedure" are gone on 10G. How can you "create function" or "procedure" any more?
How about exist "function" and "procedure"? Thanks.
--- Gints Plivna <Gints.Plivna_at_softex.lv> wrote:

> From 10g docs
> "The following CREATE statements are obfuscated:
>
> CREATE [OR REPLACE] FUNCTION function_name
> CREATE [OR REPLACE] PROCEDURE procedure_name
> CREATE [OR REPLACE] PACKAGE package_name
> CREATE [OR REPLACE] PACKAGE BODY package_name
> CREATE [OR REPLACE] TYPE type_name AS OBJECT
> CREATE [OR REPLACE] TYPE type_name UNDER type_name
> CREATE [OR REPLACE] TYPE BODY type_name
>
> Note: The CREATE [OR REPLACE] TRIGGER statement, and
> BEGIN..END
> anonymous blocks, are not obfuscated."
>
> Although you can call a [packaged] procedure from
> trigger as already
> said.
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of rjamya
> >=20
> > In 9i instead of writing your trigger code you can
> call a procedure
> > instead, and _that_ could be wrapped. Now sure of
> trigger code though
> > ...
> >=20
> > Raj
> >=20
> --
> http://www.freelists.org/webpage/oracle-l
                

---

Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

• Attached file included as plaintext by Ecartis --

Received: from [207.96.37.198] by web60803.mail.yahoo.com via HTTP; Wed, 12 Jan 2005 10:29:03 PST
Date: Wed, 12 Jan 2005 10:29:02 -0800 (PST) From: dba1 mcc <mccdba1_at_yahoo.com>
Subject: RE: Wrapping trigger code
To: Gints.Plivna_at_softex.lv
In-Reply-To: <69721CE0FE0D59478756C2926DF54E500F8747_at_saturn.softex.local> MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii Content-Length: 649

I wonder "create function", "create procedure" are gone on 10G. How can you "create function" or "procedure" any more?
How about exist "function" and "procedure"?

Thanks.
--- Gints Plivna <Gints.Plivna_at_softex.lv> wrote:

> From 10g docs
> "The following CREATE statements are obfuscated:
>
> CREATE [OR REPLACE] FUNCTION function_name
> CREATE [OR REPLACE] PROCEDURE procedure_name
> CREATE [OR REPLACE] PACKAGE package_name
> CREATE [OR REPLACE] PACKAGE BODY package_name
> CREATE [OR REPLACE] TYPE type_name AS OBJECT
> CREATE [OR REPLACE] TYPE type_name UNDER type_name
> CREATE [OR REPLACE] TYPE BODY type_name
>
> Note: The CREATE [OR REPLACE] TRIGGER statement, and
> BEGIN..END
> anonymous blocks, are not obfuscated."
>
> Although you can call a [packaged] procedure from
> trigger as already
> said.
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> > On Behalf Of rjamya
> >=20
> > In 9i instead of writing your trigger code you can
> call a procedure
> > instead, and _that_ could be wrapped. Now sure of
> trigger code though
> > ...
> >=20
> > Raj
> >=20
> --
> http://www.freelists.org/webpage/oracle-l
>
                

---

Do you Yahoo!?
The all-new My Yahoo! - Get yours free! http://my.yahoo.com  

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 12 2005 - 13:19:11 CST