rules repository

G-7515

Error

Always prefix Oracle supplied object types with owner schema name.

Stored Object Check

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
LineColumnMessage
212Prefix Oracle supplied object type json_array_t with owner schema name.
415Prefix Oracle supplied object type json_array_t with owner schema name.

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.

ParameterDescriptionDefault Value
OracleMaintainedObjectTypesComma-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
DisableAllQuickFixComma-separated list of rules for which a quick fix should not be applied to all the problems in a file.Core G-3130

References

  • similar to Trivadis G-7510

    The scope of G-7510 is packages, rather than object types.