Re: How to find PL/SQL code

--0__=y5ctfmuQXI0bIBg9R7oG3TRyuzSAUTl38SBxB2P53YJlW3KexJSPkte1
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

The trigger body is LONG.

Use set long <number> and set longchunksize <number> in sqlplus. Then you can see the rest of the code.

Winnie

Jeff Wiegand <jwiegand_at_ancept.com> on 08/10/2000 08:44:45 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: How to find PL/SQL code

Hello

We have several triggers that have been modified. Unfortunately, the modifications weren't saved, but they are reflected in the database. How can
I get Oracle to output the code of the triggers. I select on user_triggers, or all_triggers, using trigger_name and trigger_body columns, but only part of the code is outputted to the screen. How can I get all of it?

Thanks for your help.

Jeff

--0__=y5ctfmuQXI0bIBg9R7oG3TRyuzSAUTl38SBxB2P53YJlW3KexJSPkte1
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PWlzby04ODU5LTEiPg0KPE1FVEEgTkFNRT0iR2VuZXJhdG9yIiBDT05URU5U PSJNUyBFeGNoYW5nZSBTZXJ2ZXIgdmVyc2lvbiA1LjUuMjY1MC4xMiI+DQo8VElUTEU+SG93IHRv IGZpbmQgUEwvU1FMIGNvZGU8L1RJVExFPg0KPC9IRUFEPg0KPEJPRFk+DQoNCjxQPjxGT05UIFNJ WkU9Mj5IZWxsbzwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPldlIGhhdmUgc2V2ZXJh bCB0cmlnZ2VycyB0aGF0IGhhdmUgYmVlbiBtb2RpZmllZC4gVW5mb3J0dW5hdGVseSwgdGhlIG1v ZGlmaWNhdGlvbnMgd2VyZW4ndCBzYXZlZCwgYnV0IHRoZXkgYXJlIHJlZmxlY3RlZCBpbiB0aGUg ZGF0YWJhc2UuIEhvdyBjYW4gSSBnZXQgT3JhY2xlIHRvIG91dHB1dCB0aGUgY29kZSBvZiB0aGUg dHJpZ2dlcnMuIEkgc2VsZWN0IG9uIHVzZXJfdHJpZ2dlcnMsIG9yIGFsbF90cmlnZ2VycywgdXNp bmcgdHJpZ2dlcl9uYW1lIGFuZCB0cmlnZ2VyX2JvZHkgY29sdW1ucywgYnV0IG9ubHkgcGFydCBv ZiB0aGUgY29kZSBpcyBvdXRwdXR0ZWQgdG8gdGhlIHNjcmVlbi4gSG93IGNhbiBJIGdldCBhbGwg b2YgaXQ/PC9GT05UPjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPlRoYW5rcyBmb3IgeW91ciBoZWxw LjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yPkplZmY8L0ZPTlQ+DQo8L1A+DQoNCjwv Qk9EWT4NCjwvSFRNTD4NCg==

--0__=y5ctfmuQXI0bIBg9R7oG3TRyuzSAUTl38SBxB2P53YJlW3KexJSPkte1--
Received on Thu Aug 10 2000 - 16:49:06 CDT