G-7515
Error
Always prefix Oracle supplied object types with owner schema name.
Reason
The signature of Oracle supplied object types is well known and therefore it is quite easy to provide object types with the same name as those from Oracle doing something completely different without you noticing it.
Example
Non-Compliant Example
declare
o_array json_array_t;
begin
o_array := json_array_t.parse('[1,42,99]');
sys.dbms_output.put_line(o_array.to_string);
end;
/Issues
| Line | Column | Message |
|---|---|---|
| 2 | 12 | |
| 4 | 15 |
Compliant Solution - ★★★★★
declare
o_array sys.json_array_t;
begin
o_array := sys.json_array_t.parse('[1,42,99]');
sys.dbms_output.put_line(o_array.to_string);
end;
/Parameters
Use parameters to customize the rule to your needs.
| Parameter | Description | Default Value |
|---|---|---|
| OracleMaintainedObjectTypes | Comma-separated list of Oracle maintained object types with public synonyms in Oracle AI Database 26ai Free Release 23.26.0.0.0. Each object type is prefixed with its owner. | ctxsys.chunkpair, mdsys.epsg_param, mdsys.location... (click to expand)ctxsys.chunkpair, mdsys.epsg_param, mdsys.location_msg, mdsys.location_msg_pkd, mdsys.notification_msg, mdsys.pc_column_record, mdsys.pc_record, mdsys.proc_msg, mdsys.proc_msg_pkd, mdsys.rdfsa_resource, mdsys.sdoaggrtype, mdsys.sdo_closest_points_type, mdsys.sdo_dim_element, mdsys.sdo_geometry, mdsys.sdo_georaster, mdsys.sdo_geor_cell, mdsys.sdo_geor_colormap, mdsys.sdo_geor_gcp, mdsys.sdo_geor_gcpgeoreftype, mdsys.sdo_geor_grayscale, mdsys.sdo_geor_histogram, mdsys.sdo_geor_metadata, mdsys.sdo_geor_srs, mdsys.sdo_geo_addr, mdsys.sdo_interaction, mdsys.sdo_interact_line_feat, mdsys.sdo_interact_point_feat, mdsys.sdo_link_t, mdsys.sdo_mbr, mdsys.sdo_network_manager_t, mdsys.sdo_network_t, mdsys.sdo_net_feat_elem, mdsys.sdo_net_layer_feat, mdsys.sdo_net_link, mdsys.sdo_net_op, mdsys.sdo_net_upd_hist, mdsys.sdo_net_upd_hist_n, mdsys.sdo_node_t, mdsys.sdo_orgscl_type, mdsys.sdo_path_t, mdsys.sdo_pc, mdsys.sdo_pc_blk, mdsys.sdo_point_type, mdsys.sdo_range, mdsys.sdo_raster, mdsys.sdo_rdf_rowtype, mdsys.sdo_rdf_term, mdsys.sdo_rdf_triple, mdsys.sdo_rdf_triple_s, mdsys.sdo_regaggr, mdsys.sdo_region, mdsys.sdo_rowidpair, mdsys.sdo_statistics, mdsys.sdo_tgl_object, mdsys.sdo_tin, mdsys.sdo_tin_blk, mdsys.sdo_topo_geometry, mdsys.sdo_topo_geometry_layer, mdsys.sdo_topo_object, mdsys.sdo_transient_rule, mdsys.st_annotationtextelement, mdsys.st_annotationtextelement_array, mdsys.st_annotation_text, mdsys.st_circularstring, mdsys.st_compoundcurve, mdsys.st_curve, mdsys.st_curvepolygon, mdsys.st_geomcollection, mdsys.st_geometry, mdsys.st_linestring, mdsys.st_multicurve, mdsys.st_multilinestring, mdsys.st_multipoint, mdsys.st_multipolygon, mdsys.st_multisurface, mdsys.st_point, mdsys.st_polygon, mdsys.st_surface, mdsys.tfm_plan, mdsys.tin_column_record, mdsys.tin_record, mdsys.tracker_msg, sys.adr_home_t, sys.adr_incident_t, sys.adr_log_msg_arg_t, sys.adr_log_msg_ecid_t, sys.adr_log_msg_errid_t, sys.adr_log_msg_suppl_attr_t, sys.adr_log_msg_t, sys.advisor_object, sys.alert_type, sys.awrbl_details_type, sys.awrbl_metric_type, sys.awrbl_opt_env_details_type, sys.awrdrpt_text_type, sys.awrrpt_html_type, sys.awrrpt_row_type, sys.awrrpt_text_type, sys.awrsqrpt_text_type, sys.awr_export_dump_id_type, sys.awr_object, sys.awr_object_info_type, sys.cansyncrefmessage, sys.cursor_cache_object, sys.db$notification, sys.db$notificationid, sys.dbms_aw$_dimension_source_t, sys.dbms_dbfs_content_context_t, sys.dbms_dbfs_content_list_item_t, sys.dbms_dbfs_content_property_t, sys.dbms_dbfs_hs_item_t, sys.dbms_lobutil_dedupset_t, sys.dbms_lobutil_inode_t, sys.dbms_lobutil_lobextent_t, sys.dbms_lobutil_lobmap_t, sys.dbms_xa_xid, sys.dbms_xs_nsattr, sys.dburitype, sys.dir_entry_t, sys.dm_centroid, sys.dm_child, sys.dm_cluster, sys.dm_conditional, sys.dm_cost_element, sys.dm_em_component, sys.dm_em_projection, sys.dm_glm_coeff, sys.dm_histogram_bin, sys.dm_item, sys.dm_itemset, sys.dm_model_global_detail, sys.dm_model_setting, sys.dm_model_signature_attribute, sys.dm_model_text_df, sys.dm_nb_detail, sys.dm_nested_binary_double, sys.dm_nested_binary_float, sys.dm_nested_categorical, sys.dm_nested_numerical, sys.dm_nmf_attribute, sys.dm_nmf_feature, sys.dm_predicate, sys.dm_ranked_attribute, sys.dm_rule, sys.dm_svd_matrix, sys.dm_svm_attribute, sys.dm_svm_linear_coeff, sys.dm_transform, sys.explainmvmessage, sys.ftpuritype, sys.generic_plan_object, sys.geninterfacestub, sys.genolapiexception, sys.httpuritype, sys.job, sys.jobarg, sys.jobattr, sys.job_definition, sys.json_array_t, sys.json_element_t, sys.json_object_t, sys.json_scalar_t, sys.ku$_auddef_t, sys.ku$_audobj_t, sys.ku$_chunk_t, sys.ku$_ddl, sys.ku$_dumpfile1010, sys.ku$_dumpfile_item, sys.ku$_errorline, sys.ku$_java_t, sys.ku$_jobdesc1010, sys.ku$_jobdesc1020, sys.ku$_jobdesc1210, sys.ku$_jobdesc1220, sys.ku$_jobstatus1010, sys.ku$_jobstatus1020, sys.ku$_jobstatus1120, sys.ku$_jobstatus1210, sys.ku$_jobstatus1220, sys.ku$_logline1010, sys.ku$_multi_ddl, sys.ku$_objnumnam, sys.ku$_objnumpair, sys.ku$_paramvalue1010, sys.ku$_parsed_item, sys.ku$_procobj_line, sys.ku$_procobj_loc, sys.ku$_source_t, sys.ku$_status1010, sys.ku$_status1020, sys.ku$_status1120, sys.ku$_status1210, sys.ku$_status1220, sys.ku$_submitresult, sys.ku$_taction_t, sys.ku$_workerstatus1010, sys.ku$_workerstatus1020, sys.ku$_workerstatus1120, sys.ku$_workerstatus1210, sys.ku$_workerstatus1220, sys.olap_srf_t, sys.ora_mining_table_type, sys.plan_params, sys.plan_table_object, sys.rewritemessage, sys.spm_object, sys.sqlset_object, sys.sqlset_row, sys.sql_bind, sys.sql_plan_allstat_row_type, sys.sql_plan_row_type, sys.sql_plan_stat_row_type, sys.sql_profile_object, sys.uritype, sys.utl_binaryinputstream, sys.utl_binaryoutputstream, sys.utl_characterinputstream, sys.utl_characteroutputstream, sys.wlm_capability_object, sys.wri$_rept_abstract_t, sys.wri$_rept_addm, sys.wri$_rept_arc, sys.wri$_rept_ash, sys.wri$_rept_ash_omx, sys.wri$_rept_autoim, sys.wri$_rept_auto_clustering, sys.wri$_rept_auto_index, sys.wri$_rept_auto_mv, sys.wri$_rept_auto_zonemap, sys.wri$_rept_awrv, sys.wri$_rept_cell, sys.wri$_rept_config, sys.wri$_rept_cpaddm, sys.wri$_rept_dbhome, sys.wri$_rept_dbreplay, sys.wri$_rept_emx_perf, sys.wri$_rept_memory, sys.wri$_rept_optstats, sys.wri$_rept_perf, sys.wri$_rept_plan_diff, sys.wri$_rept_rsrcmgr, sys.wri$_rept_rtaddm, sys.wri$_rept_security, sys.wri$_rept_session, sys.wri$_rept_spmevolve, sys.wri$_rept_sqldetail, sys.wri$_rept_sqlhistory, sys.wri$_rept_sqlmonitor, sys.wri$_rept_sqlpi, sys.wri$_rept_sqlt, sys.wri$_rept_statsadv, sys.wri$_rept_storage, sys.wri$_rept_tcb, sys.wri$_rept_xplan, sys.wrw_mailpkg_info_type, sys.xdburitype, sys.xmlbinaryinputstream, sys.xmlbinaryoutputstream, sys.xmlcharacterinputstream, sys.xmlcharacteroutputstream, sys.xs$ace_type, sys.xs$column_constraint_type, sys.xs$key_type, sys.xs$ns_attribute, sys.xs$privilege, sys.xs$realm_constraint_type, sys.xs$role_grant_type, wmsys.wm_period, xdb.dbms_xmlschema_resmd, xdb.dbms_xmlschema_tabmd |
| DisableAllQuickFix | Comma-separated list of rules for which a quick fix should not be applied to all the problems in a file. | Core G-3130 |