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

VHJ5aW5nIGFnYWluLCBhcyBpdCBzZWVtcyBnTWFpbCBlbmNvZGVkIG15IHByZXZpb3VzIG1lc3Nh Z2UgYXMgQmFzZSA2NC4KCkkgaGF2ZSBmb3VuZCBhbiBpbnRlcmVzdGluZyBzaXR1YXRpb24gaGVy ZSwgYW5kIGhhdmUgcnVuIG91dCBvZiBpZGVhcy4KQSBsb2dvbiB0cmlnZ2VyIHdhcyBjcmVhdGVk IChieSBhIGxvbmctZ29uZSBjb2xsYWJvcmF0b3IpIGluIHRoZSBTWVMKc2NoZW1hIGFuZCB1c2lu ZyBwdWJsaWMgc3lub255bXMuICBJdCB3YXMgcmVtb3ZlZCBieSBhY2NpZGVudCBmcm9tIG91cgp0 ZXN0aW5nIGVudmlyb25tZW50IGJ5IHRoZSBEQkEsIGFuZCByZWNyZWF0ZWQgYnkgY29weWluZyB0 aGUgb25lIGluCnRoZSBwcm9kdWN0aW9uIGVudmlyb25tZW50LiAgT25seSBpdCBub3cgZmFpbHMg dG8gY29tcGlsZSwgYWxsZWdpbmcKdGFibGUgbm90IGZvdW5kLgoKSSB3aWxsIGFwcHJlY2lhdGUg YW55IGlkZWEuICBEZXRhaWxzIGZvbGxvdyBiZWxvdy4KClRoZSB0cmlnZ2VyOgoKQ1JFQVRFIE9S IFJFUExBQ0UgVFJJR0dFUgogICAgIHN5cy50Z19kc3Nfc2VydmVyX2Fsb2dvbgpBRlRFUiBMT0dP TgogIE9OIERBVEFCQVNFCkRFQ0xBUkUKbkNvbnQgIEJJTkFSWV9JTlRFR0VSOwpscHN6R1YgVkFS Q0hBUjIoMzApOwpiQXRpdm8gQk9PTEVBTjsKQkVHSU4KYkF0aXZvIDo9IEZBTFNFOwoKLyogUG9s w610aWNhIDEg4oCUIHNlIHVzdcOhcmlvIGZvciBleGVjdXRpdm8gZW50w6NvIHBvZGVyw6EgdmVy IHR1ZG8uCiovCmxwc3pHViA6PSAnRFNTX0VYRUNVVElWTyc7ClNFTEVDVCBDT1VOVCgqKSBJTlRP IG5Db250IEZST00gREJBX1JPTEVfUFJJVlMgV0hFUkUgR1JBTlRFRSA9IFVTRVIKQU5EIEdSQU5U RURfUk9MRSA9IGxwc3pHVjsKCklGIChuQ29udCA+IDApIFRIRU4KICBJTlNFUlQgSU5UTwogICAg ICAgICBkc3NfYWxjYWRhX3Zpc2FvICh0aXBvLCBjaGF2ZSkKICBTRUxFQ1QKICAgICAgICAgJ0NS JywKICAgICAgICAgc2VtZWwuY29kaV9jYwogICAgRlJPTQogICAgICAgICBkc3NfY2VudHJvX2N1 c3RvICAgICAgICAgICAgc2VtZWwKICAgV0hFUkUgY29kaV9jYyAgICAgICAgICAgICAgICAgICAg ICE9ICdHTE9CQUwnCiA7CgogIElOU0VSVCBJTlRPIGRzc19hbGNhZGFfdmlzYW8gKHRpcG8sIGNo YXZlKQogIFNFTEVDVAogICAgICAgICBERUNPREUgKExFTkdUSCAoY29kaV9jb21wb25lbnRlKSwg MiwgJ0RSJywgJ0FSJyksCiAgICAgICAgIHNlbWVsLmNvZGlfY29tcG9uZW50ZQogICAgRlJPTQog ICAgICAgICBkc3NfZXN0cnV0dXJhX2F0ZWNoICAgICAgICAgc2VtZWwKICAgV0hFUkUKICAgICAg ICAgc2VtZWwuY29kaV9jb21wb25lbnRlICAgICAgICE9ICctLSc7CgogIElOU0VSVCBJTlRPIGRz c19hbGNhZGFfdmlzYW8gKHRpcG8sIGNoYXZlKSBWQUxVRVMgKCcqKicsJyoqKioqKioqKicpOwoK IGJBdGl2byA6PSBUUlVFOwoKLyogUG9sw610aWNhIDIg4oCUIHNlIHVzdcOhcmlvIHRpdmVyIGFs Z3VtIHRpcG8gZGUgYXNzb2NpYcOnw6NvIGNvbSBvCmNlbnRybyBkZSBjdXN0byBlbnTDo28gbW9u dGEgYSBhbMOnYWRhCiAgZGUgdmlzw6NvIGNvcnJldGEuCiovCkVMU0UKIGxwc3pHViA6PSAnRFNT X1JFU1BPTlNBVkVMX0NDJzsKICBTRUxFQ1QgQ09VTlQoKikgSU5UTyBuQ29udCBGUk9NIERCQV9S T0xFX1BSSVZTIFdIRVJFIEdSQU5URUUgPQpVU0VSIEFORCBHUkFOVEVEX1JPTEUgPSBscHN6R1Y7 CgogSUYgKG5Db250ID4gMCkgVEhFTgogICAgSU5TRVJUIElOVE8gZHNzX2FsY2FkYV92aXNhbyAo dGlwbywgY2hhdmUpCiAgICBTRUxFQ1QgRElTVElOQ1QKICAgICAgICAgICAnQ1InLAogICAgICAg ICAgIHNlbWVsLmNvZGlfY2MKICAgICAgRlJPTQogICAgICAgICAgIGRzc19jb2xhYm9yYWRvciAg ICAgICAgICAgY29sYWIKICAgICBJTk5FUiBKT0lOCiAgICAgICAgICAgZHNzX21hcGFfcmVzcG9u c2FiaWxpZGFkZSBtYXBhIE9OIChjb2xhYi5pZGVuX2NvbGFiID0KbWFwYS5pZGVuX2NvbGFiKSBK T0lOCiAgICAgICAgICAgZHNzX2NlbnRyb19jdXN0byAgICAgICAgICBpZ3VhbCBPTiAobWFwYS5j b2RpX2NjID0KaWd1YWwuY29kaV9jYykgSk9JTgogICAgICAgICAgIGRzc19jZW50cm9fY3VzdG8g ICAgICAgICAgc2VtZWwgT04gKHNlbWVsLmNvZGlfY2MgTElLRQooaWd1YWwuY29kaV9jYyB8fCAn JScpKQogICAgV0hFUkUKICAgICBjb2xhYi51c2VybmFtZSA9IFVTRVI7CgogICAgSU5TRVJUIElO VE8gZHNzX2FsY2FkYV92aXNhbyAodGlwbywgY2hhdmUpCiAgICBTRUxFQ1QgRElTVElOQ1QKICAg ICAgICAgICBERUNPREUoTEVOR1RIKHNlbWVsLmNvZGlfY29tcG9uZW50ZSksIDIsICdEUicsICdB UicpLAogICAgICAgICAgIHNlbWVsLmNvZGlfY29tcG9uZW50ZQogICAgICBGUk9NCiAgICAgICAg ICAgZHNzX2NvbGFib3JhZG9yICAgICAgICAgICBjb2xhYiBKT0lOCiAgICAgICAgICAgZHNzX2Vz dHJ1dHVyYV9hdGVjaCAgICAgICBpZ3VhbCBPTiAoY29sYWIuaWRlbl9jb2xhYiA9CmlndWFsLmlk ZW5fY29sYWJfcmVzcCkgSk9JTgogICAgICAgICAgIGRzc19lc3RydXR1cmFfYXRlY2ggICAgICAg c2VtZWwKICAgICAgICBPTiAoc2VtZWwuY29kaV9jb21wb25lbnRlICAgIExJS0UgKGlndWFsLmNv ZGlfY29tcG9uZW50ZSB8fCAnJScpKQogICAgV0hFUkUKICAgICBjb2xhYi51c2VybmFtZSA9IFVT RVI7CgogICBiQXRpdm8gOj0gVFJVRTsKCiBFTkQgSUY7CgpFTkQgSUY7CgovKiBTZSBvIHVzdcOh cmlvIGZvciBEQkEgZW50w6NvIG7Do28gcmVnaXN0cmEgbyBhbGVydGEgZGUgbG9nb24gbm8gRFNT LgoqLwpTRUxFQ1QgQ09VTlQoKikgSU5UTyBuQ29udCBGUk9NIERCQV9ST0xFX1BSSVZTIFdIRVJF IEdSQU5URUUgPSBVU0VSCkFORCBHUkFOVEVEX1JPTEUgPSAnREJBJzsKSUYgKG5Db250ID4gMCkg VEhFTgogICAgIGJBdGl2byA6PSBGQUxTRTsKRU5EIElGOwoKSUYgKGJBdGl2byA9IFRSVUUpIFRI RU4KIFNZU19EU1MuRFNTX0FMRVJUQS5yZWdpc3RyYXJBbGVydGEgKCdMT0dJTicsIFVTRVIsIDQw MDA1LCBVU0VSIHx8CiclcycgfHwgbHBzekdWKTsKRU5EIElGOwpFTkQgdGdfZHNzX3NlcnZlcl9h bG9nb247Ci8KCkF2ZXJ0aXNzZW1lbnQgOiBEw6ljbGVuY2hldXIgY3LDqcOpIGF2ZWMgZXJyZXVy cyBkZSBjb21waWxhdGlvbi4KCjEwOjQzOjE5IFNRTD4gU0hPVyBFUlIgVFJJR0dFUiBzeXMudGdf ZHNzX3NlcnZlcl9hbG9nb24KRXJyZXVycyBwb3VyIFRSSUdHRVIgU1lTLlRHX0RTU19TRVJWRVJf QUxPR09OIDoKCkxJTkUvQ09MIEVSUk9SCi0tLS0tLS0tIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCjE2LzUgICAgIFBML1NR TDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjE2LzE3ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJs ZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjI0LzUgICAgIFBML1NRTDogU1FMIFN0YXRlbWVudCBp Z25vcmVkCjI0LzE3ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMgbm90 IGV4aXN0CjMzLzUgICAgIFBML1NRTDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjMzLzE3ICAgIFBM L1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjQ4LzcgICAgIFBM L1NRTDogU1FMIFN0YXRlbWVudCBpZ25vcmVkCjQ4LzE5ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0 YWJsZSBvciB2aWV3IGRvZXMgbm90IGV4aXN0CjYwLzcgICAgIFBML1NRTDogU1FMIFN0YXRlbWVu dCBpZ25vcmVkCjYwLzE5ICAgIFBML1NRTDogT1JBLTAwOTQyOiB0YWJsZSBvciB2aWV3IGRvZXMg bm90IGV4aXN0CgoKTmV2ZXJ0aGVsZXNzOgoKVVNFUiBlc3QgIlNZUyIKMTE6MDI6MjMgU1FMPiBT RUxFQ1QgQ09VTlQoKikgRlJPTSBEQkFfUk9MRV9QUklWUzsKCkNPVU5UKCopCi0tLS0tLS0tLS0K ICAgIDIyOAoKRWNvdWzDqSA6IDAwIDowMCA6MDAuMDEKMTE6MzE6MTggU1FMPiAgICAgU0VMRUNU CiAgICAgQ09VTlQgKCopCiBGUk9NCiAgIGRzc19jZW50cm9fY3VzdG8gc2VtZWwKIFdIRVJFIGNv ZGlfY2MgIT0gJ0dMT0JBTCc7CgoxMTozMToyNgpDT1VOVCgqKQotLS0tLS0tLS0tCiAgICA5NTcK CkVjb3Vsw6kgOiAwMCA6MDAgOjAwLjE5CjExOjMxOjI3IFNRTD4gMTE6MzE6MjcgU1FMPgoKClRo YW5rcyBpbiBhZHZhbmNlIQoKLS0Kc2t5cGU6bGVhbmRyby5nZmMuZHV0cmE/Y2hhdCBZYWhvbyE6 IHltc2dyOnNlbmRJTT9sZ2NkdXRyYQorNTUgKDExKSAzMDQwIDczMDAgcjE1NSBnVGFsazogeG1w cDpsZWFuZHJvZEBqYWJiZXIub3JnCis1NSAoMTEpIDk0MDYgNzE5MSBJQ1EvQUlNOiBhaW06R29J TT9zY3JlZW5uYW1lPTYxMjg3ODAzCis1NSAoMTEpIDU2ODUgMjIxOSBNU046IG1zbmltOmNoYXQ/ Y29udGFjdD1sZWFuZHJvQGR1dHJhLmZhc3RtYWlsLmZtCg==

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