Compilation errors due to access privilege or public synonym errors in SYS trigger

From: Leandro DUTRA <leandro.gfc.dutra_at_gmail.com>
Date: Wed, 4 Jun 2008 13:06:33 -0300
Message-ID: <43d2a660806040906v539dfc2sebf7557f30a52ebe@mail.gmail.com>

SSBoYXZlIGZvdW5kIGFuIGludGVyZXN0aW5nIHNpdHVhdGlvbiBoZXJlLCBhbmQgaGF2ZSBydW4g b3V0IG9mIGlkZWFzLgogQSBsb2dvbiB0cmlnZ2VyIHdhcyBjcmVhdGVkIChieSBhIGxvbmctZ29u ZSBjb2xsYWJvcmF0b3IpIGluIHRoZSBTWVMKc2NoZW1hIGFuZCB1c2luZyBwdWJsaWMgc3lub255 bXMuICBJdCB3YXMgcmVtb3ZlZCBieSBhY2NpZGVudCBmcm9tIG91cgp0ZXN0aW5nIGVudmlyb25t ZW50IGJ5IHRoZSBEQkEsIGFuZCByZWNyZWF0ZWQgYnkgY29weWluZyB0aGUgb25lIGluCnRoZSBw cm9kdWN0aW9uIGVudmlyb25tZW50LiAgT25seSBpdCBub3cgZmFpbHMgdG8gY29tcGlsZSwgYWxs ZWdpbmcKdGFibGUgbm90IGZvdW5kLgoKSSB3aWxsIGFwcHJlY2lhdGUgYW55IGlkZWEuICBEZXRh aWxzIGZvbGxvdyBiZWxvdy4KClRoZSB0cmlnZ2VyOgoKIENSRUFURSBPUiBSRVBMQUNFIFRSSUdH RVIKICAgICAgIHN5cy50Z19kc3Nfc2VydmVyX2Fsb2dvbgogQUZURVIgTE9HT04KICAgIE9OIERB VEFCQVNFCkRFQ0xBUkUKIG5Db250ICBCSU5BUllfSU5URUdFUjsKIGxwc3pHViBWQVJDSEFSMigz MCk7CiBiQXRpdm8gQk9PTEVBTjsKQkVHSU4KIGJBdGl2byA6PSBGQUxTRTsKCiAvKiBQb2zDrXRp Y2EgMSDigJQgc2UgdXN1w6FyaW8gZm9yIGV4ZWN1dGl2byBlbnTDo28gcG9kZXLDoSB2ZXIgdHVk by4KICAqLwogbHBzekdWIDo9ICdEU1NfRVhFQ1VUSVZPJzsKICBTRUxFQ1QgQ09VTlQoKikgSU5U TyBuQ29udCBGUk9NIERCQV9ST0xFX1BSSVZTIFdIRVJFIEdSQU5URUUgPSBVU0VSCkFORCBHUkFO VEVEX1JPTEUgPSBscHN6R1Y7CgogSUYgKG5Db250ID4gMCkgVEhFTgogICAgSU5TRVJUIElOVE8K ICAgICAgICAgICBkc3NfYWxjYWRhX3Zpc2FvICh0aXBvLCBjaGF2ZSkKICAgIFNFTEVDVAogICAg ICAgICAgICdDUicsCiAgICAgICAgICAgc2VtZWwuY29kaV9jYwogICAgICBGUk9NCiAgICAgICAg ICAgZHNzX2NlbnRyb19jdXN0byAgICAgICAgICAgIHNlbWVsCiAgICAgV0hFUkUgY29kaV9jYyAg ICAgICAgICAgICAgICAgICAgICE9ICdHTE9CQUwnCiAgIDsKCiAgICBJTlNFUlQgSU5UTyBkc3Nf YWxjYWRhX3Zpc2FvICh0aXBvLCBjaGF2ZSkKICAgIFNFTEVDVAogICAgICAgICAgIERFQ09ERSAo TEVOR1RIIChjb2RpX2NvbXBvbmVudGUpLCAyLCAnRFInLCAnQVInKSwKICAgICAgICAgICBzZW1l bC5jb2RpX2NvbXBvbmVudGUKICAgICAgRlJPTQogICAgICAgICAgIGRzc19lc3RydXR1cmFfYXRl Y2ggICAgICAgICBzZW1lbAogICAgIFdIRVJFCiAgICAgICAgICAgc2VtZWwuY29kaV9jb21wb25l bnRlICAgICAgICE9ICctLSc7CgogICAgSU5TRVJUIElOVE8gZHNzX2FsY2FkYV92aXNhbyAodGlw bywgY2hhdmUpIFZBTFVFUyAoJyoqJywnKioqKioqKioqJyk7CgogICBiQXRpdm8gOj0gVFJVRTsK CiAvKiBQb2zDrXRpY2EgMiDigJQgc2UgdXN1w6FyaW8gdGl2ZXIgYWxndW0gdGlwbyBkZSBhc3Nv Y2lhw6fDo28gY29tIG8KY2VudHJvIGRlIGN1c3RvIGVudMOjbyBtb250YSBhIGFsw6dhZGEKICAg IGRlIHZpc8OjbyBjb3JyZXRhLgogKi8KIEVMU0UKICAgbHBzekdWIDo9ICdEU1NfUkVTUE9OU0FW RUxfQ0MnOwogICAgU0VMRUNUIENPVU5UKCopIElOVE8gbkNvbnQgRlJPTSBEQkFfUk9MRV9QUklW UyBXSEVSRSBHUkFOVEVFID0KVVNFUiBBTkQgR1JBTlRFRF9ST0xFID0gbHBzekdWOwoKICAgSUYg KG5Db250ID4gMCkgVEhFTgogICAgICBJTlNFUlQgSU5UTyBkc3NfYWxjYWRhX3Zpc2FvICh0aXBv LCBjaGF2ZSkKICAgICAgU0VMRUNUIERJU1RJTkNUCiAgICAgICAgICAgICAnQ1InLAogICAgICAg ICAgICAgc2VtZWwuY29kaV9jYwogICAgICAgIEZST00KICAgICAgICAgICAgIGRzc19jb2xhYm9y YWRvciAgICAgICAgICAgY29sYWIKICAgICAgIElOTkVSIEpPSU4KICAgICAgICAgICAgIGRzc19t YXBhX3Jlc3BvbnNhYmlsaWRhZGUgbWFwYSBPTiAoY29sYWIuaWRlbl9jb2xhYiA9Cm1hcGEuaWRl bl9jb2xhYikgSk9JTgogICAgICAgICAgICAgZHNzX2NlbnRyb19jdXN0byAgICAgICAgICBpZ3Vh bCBPTiAobWFwYS5jb2RpX2NjID0KaWd1YWwuY29kaV9jYykgSk9JTgogICAgICAgICAgICAgZHNz X2NlbnRyb19jdXN0byAgICAgICAgICBzZW1lbCBPTiAoc2VtZWwuY29kaV9jYyBMSUtFCihpZ3Vh bC5jb2RpX2NjIHx8ICclJykpCiAgICAgIFdIRVJFCiAgICAgICBjb2xhYi51c2VybmFtZSA9IFVT RVI7CgogICAgICBJTlNFUlQgSU5UTyBkc3NfYWxjYWRhX3Zpc2FvICh0aXBvLCBjaGF2ZSkKICAg ICAgU0VMRUNUIERJU1RJTkNUCiAgICAgICAgICAgICBERUNPREUoTEVOR1RIKHNlbWVsLmNvZGlf Y29tcG9uZW50ZSksIDIsICdEUicsICdBUicpLAogICAgICAgICAgICAgc2VtZWwuY29kaV9jb21w b25lbnRlCiAgICAgICAgRlJPTQogICAgICAgICAgICAgZHNzX2NvbGFib3JhZG9yICAgICAgICAg ICBjb2xhYiBKT0lOCiAgICAgICAgICAgICBkc3NfZXN0cnV0dXJhX2F0ZWNoICAgICAgIGlndWFs IE9OIChjb2xhYi5pZGVuX2NvbGFiID0KaWd1YWwuaWRlbl9jb2xhYl9yZXNwKSBKT0lOCiAgICAg ICAgICAgICBkc3NfZXN0cnV0dXJhX2F0ZWNoICAgICAgIHNlbWVsCiAgICAgICAgICBPTiAoc2Vt ZWwuY29kaV9jb21wb25lbnRlICAgIExJS0UgKGlndWFsLmNvZGlfY29tcG9uZW50ZSB8fCAnJScp KQogICAgICBXSEVSRQogICAgICAgY29sYWIudXNlcm5hbWUgPSBVU0VSOwoKICAgICBiQXRpdm8g Oj0gVFJVRTsKCiAgIEVORCBJRjsKCiBFTkQgSUY7CgogLyogU2UgbyB1c3XDoXJpbyBmb3IgREJB IGVudMOjbyBuw6NvIHJlZ2lzdHJhIG8gYWxlcnRhIGRlIGxvZ29uIG5vIERTUy4KICAqLwogU0VM RUNUIENPVU5UKCopIElOVE8gbkNvbnQgRlJPTSBEQkFfUk9MRV9QUklWUyBXSEVSRSBHUkFOVEVF ID0gVVNFUgpBTkQgR1JBTlRFRF9ST0xFID0gJ0RCQSc7CiBJRiAobkNvbnQgPiAwKSBUSEVOCiAg ICAgICBiQXRpdm8gOj0gRkFMU0U7CiBFTkQgSUY7CgogSUYgKGJBdGl2byA9IFRSVUUpIFRIRU4K ICAgU1lTX0RTUy5EU1NfQUxFUlRBLnJlZ2lzdHJhckFsZXJ0YSAoJ0xPR0lOJywgVVNFUiwgNDAw MDUsIFVTRVIgfHwKJyVzJyB8fCBscHN6R1YpOwogRU5EIElGOwpFTkQgdGdfZHNzX3NlcnZlcl9h bG9nb247Ci8KCkF2ZXJ0aXNzZW1lbnQgOiBEw6ljbGVuY2hldXIgY3LDqcOpIGF2ZWMgZXJyZXVy cyBkZSBjb21waWxhdGlvbi4KCjEwOjQzOjE5IFNRTD4gU0hPVyBFUlIgVFJJR0dFUiBzeXMudGdf ZHNzX3NlcnZlcl9hbG9nb24KRXJyZXVycyBwb3VyIFRSSUdHRVIgU1lTLlRHX0RTU19TRVJWRVJf QUxPR09OIDoKCkxJTkUvQ09MIEVSUk9SCi0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCjE2LzUgICAgIFBML1NR TDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjE2LzE3ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJs ZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjI0LzUgICAgIFBML1NRTDogU1FMIFN0YXRlbWVudCBp Z25vcmVkCjI0LzE3ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMgbm90 IGV4aXN0CjMzLzUgICAgIFBML1NRTDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjMzLzE3ICAgIFBM L1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjQ4LzcgICAgIFBM L1NRTDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjQ4LzE5ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0 YWJsZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjYwLzcgICAgIFBML1NRTDogU1FMIFN0YXRlbWVu dCBpZ25vcmVkCjYwLzE5ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMg bm90IGV4aXN0CgoKTmV2ZXJ0aGVsZXNzOgoKVVNFUiBlc3QgIlNZUyIKMTE6MDI6MjMgU1FMPiBT RUxFQ1QgQ09VTlQoKikgRlJPTSBEQkFfUk9MRV9QUklWUzsKCiBDT1VOVCgqKQotLS0tLS0tLS0t CiAgICAgIDIyOAoKRWNvdWzDqSA6IDAwIDowMCA6MDAuMDEKMTE6MzE6MTggU1FMPiAgICAgU0VM RUNUCiAgICAgICBDT1VOVCAoKikKICAgRlJPTQogICAgIGRzc19jZW50cm9fY3VzdG8gc2VtZWwK ICAgV0hFUkUgY29kaV9jYyAhPSAnR0xPQkFMJzsKCjExOjMxOjI2CiBDT1VOVCgqKQotLS0tLS0t LS0tCiAgICAgIDk1NwoKRWNvdWzDqSA6IDAwIDowMCA6MDAuMTkKMTE6MzE6MjcgU1FMPiAxMToz MToyNyBTUUw+CgoKVGhhbmtzIGluIGFkdmFuY2UhCgotLSAKc2t5cGU6bGVhbmRyby5nZmMuZHV0 cmE/Y2hhdCBZYWhvbyE6IHltc2dyOnNlbmRJTT9sZ2NkdXRyYQorNTUgKDExKSAzMDQwIDczMDAg cjE1NSBnVGFsazogeG1wcDpsZWFuZHJvZEBqYWJiZXIub3JnCis1NSAoMTEpIDk0MDYgNzE5MSBJ Q1EvQUlNOiBhaW06R29JTT9zY3JlZW5uYW1lPTYxMjg3ODAzCis1NSAoMTEpIDU2ODUgMjIxOSBN U046IG1zbmltOmNoYXQ/Y29udGFjdD1sZWFuZHJvQGR1dHJhLmZhc3RtYWlsLmZtCg==

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

Received on Wed Jun 04 2008 - 11:06:33 CDT

This message: [ Message body ]
Next message: Leandro DUTRA: "AutoDoc for Oracle?"
Previous message: Charles Schultz: "Re: Enterprise Manager documentation, a rant and 11g availability"
Next in thread: Jared Still: "Re: Compilation errors due to access privilege or public synonym errors in SYS trigger"
Reply: Jared Still: "Re: Compilation errors due to access privilege or public synonym errors in SYS trigger"
Reply: Leandro DUTRA: "Fwd: Compilation errors due to access privilege or public synonym errors in SYS trigger"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message