RE: Wrapping trigger code

>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