Fwd: RE: Wrapping trigger code
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 12 Jan 2005 10:56:59 -0800 (PST)
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@xxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > 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
> --
> //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@xxxxxxxxx>
Subject: RE: Wrapping trigger code
To: Gints.Plivna@xxxxxxxxx
In-Reply-To: <69721CE0FE0D59478756C2926DF54E500F8747@xxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > 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
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Fwd: RE: Wrapping trigger code
