#Procedures

ORA-12420: required procedures and functions not in policy package “string”

文档解释ORA-12420:requiredproceduresandfunctionsnotinpolicypackage“string”Cause:Thepolicypackagedidnotcontainalloftheproceduresandfunctionsnecessarytoen...

ORA-01984: invalid auditing option for procedures/packages/functions

文档解释ORA-01984:invalidauditingoptionforprocedures/packages/functionsCause:AUDITorNOAUDITonaDEFAULTspecifiesanauditingoptionthatisnotlegalforprocedures,packages,o...

ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures

文档解释ORA-02225:onlyEXECUTEandDEBUGprivilegesarevalidforproceduresCause:Anattemptwasmadetograntorrevokeaninvalidprivilegeonaprocedure,functionorpackage.Action:Don...

ORA-00991: only MAC privileges may be granted to procedures

文档解释ORA-00991:onlyMACprivilegesmaybegrantedtoproceduresCause:Objectprivilegesornon-MACsystemprivilegesweregrantedtotheprocedure.Action:OnlygrantMACprivilegesusi...

(在数据库中调用webservices。)SQL Server 阻止了对组件 'Ole Automation Procedures' 的 过程'sys.sp_OACreate' 的访问

 出现问题之后执行以下语句就行了--开启OleAutomationProceduressp_configure'showadvancedoptions',1;GORECONFIGURE;GOsp_configure'OleAutomationProcedures',1;GORECONFIGURE;GOEXEC...