OceanBase 数据库 Oracle 租户使用 ALTER 语句预编译函数报错 -4016, Internal error 的原因及解决方法

obclient> alter function function_name compile;
ORA-00600: internal error code, arguments: -4016, Internal error

[2024-12-20 12:20:18.058932] WDIAG [SQL.RESV] resolve_routine (ob_alter_routine_resolver.cpp:345) [58316][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=5][errcode=-4016] invalid arguments(T_SP_SOURCE == source_tree->type_ || T_SF_SOURCE == source_tree->type_=false)
[2024-12-20 12:20:18.058939] WDIAG [SQL.RESV] resolve_compile_clause (ob_alter_routine_resolver.cpp:217) [58316][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=7][errcode=-4016] fail to exec resolve_routine(crt_routine_arg, routine_info, need_recreate, parse_tree)(ret=-4016)
[2024-12-20 12:20:18.058946] WDIAG [SQL.RESV] resolve_impl (ob_alter_routine_resolver.cpp:157) [58316][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=6][errcode=-4016] fail to exec resolve_compile_clause(crt_routine_arg, routine_info, alter_clause_node)(ret=-4016)
[2024-12-20 12:20:18.058949] WDIAG [SQL.RESV] resolve (ob_alter_routine_resolver.cpp:92) [58316][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=3][errcode=-4016] fail to exec resolve_impl( alter_routine_stmt->get_routine_arg(), *routine_info, *(parse_tree.children_[1]))(ret=-4016)
[2024-12-20 12:20:18.058955] WDIAG [SQL.RESV] stmt_resolver_func (ob_resolver.cpp:168) [58316][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=6][errcode=-4016] execute stmt_resolver failed(ret=-4016, parse_tree.type_=3914)