Forum Stats

  • 3,769,310 Users
  • 2,252,947 Discussions
  • 7,874,983 Comments

Discussions

SQLDeveloper crashes if the input in Arbori-Editor is too large

User_V01BE
User_V01BE Member Posts: 4
edited May 19, 2020 9:06AM in SQL Developer

If I enter a large Set-content in the Arbori-Editor, the SQLDeveloper freezes.

Is it a bug or is it not allowed?

My entry was:

include "std.arbori"

declare: runOnce -> {

var keywords = new java.util.HashSet(

  ['a','abort','abs','absent','accessed','account','acl','acos','across','action','actions','activate','active',
   'active_component','active_data','active_function','active_tag','activity','adaptive_plan','add_column',
   'add_group','add_months','adg_redirect_dml','adg_redirect_plsql','adj_date','admin','administer',
   'administrator','advanced','advise','advisor','afd_diskstring','affinity','after','aggregate','aggregates',
   'algorithm','alias','allocate','allow','all_rows','alternate','always','analytic','analyze','ancestor',
   'ancillary','and_equal','anomaly','ansi_rearch','answer_query_using_stats','antijoin','anyschema','append',
   'appendchildxml','append_values','application','apply','approx_count','approx_count_distinct',
   'approx_count_distinct_agg','approx_count_distinct_detail','approx_median','approx_percentile',
   'approx_percentile_agg','approx_percentile_detail','approx_rank','approx_sum','archival','archive',
   'archived','archivelog','array','ascii','asciistr','asin','asis','assembly','assign','associate','async',
   'asynchronous','as_json','at','atan','atan2','attribute','attributes','authenticated','authentication',
   'authid','authorization','auto','autoallocate','autoextend','automatic','auto_login','auto_reoptimize',
   'availability','avcache_op','average_rank','avg','avmdx_op','avro','av_cache','aw','background','backup',
   'band_join','basic','basicfile','batch','batchsize','batch_table_access_by_rowid','become','before','begin',
   'beginning','begin_outline_data','behalf','bequeath','bfile','bfilename','bigfile','binary','binary_double',
   'binary_double_infinity','binary_double_nan','binary_float','binary_float_infinity','binary_float_nan',
   'binding','bind_aware','bin_to_num','bitand','bitmap','bitmaps','bitmap_and','bitmap_tree','bits','blob',
   'block','blocks','blocksize','block_range','body','both','bound','branch','breadth','broadcast','bson',
   'buffer','buffer_cache','buffer_pool','build','bulk','bushy_join','bypass_recursive_check','bypass_ujvc',
   'byte','cache','cache_cb','cache_instances','cache_temp_table','caching','calculated','call','callback',
   'cancel','capacity','caption','cardinality','cascade','case','cast','category','cdb$default','cdb_http_handler',
   'ceil','cellmemory','cell_flash_cache','certificate','cfile','chained','change','change_dupkey_error_index',
   'character','chartorowid','char_cs','checkpoint','check_acl_rewrite','child','choose','chr','chunk','class',
   'classification','classifier','clause','clean','cleanup','clear','client','clob','clone','close','closest',
   'close_cached_open_cursors','clustering','clustering_factor','cluster_by_rowid','cluster_details',
   'cluster_distance','cluster_id','cluster_probability','cluster_set','coalesce','coalesce_sq','coarse',
   'cold','collate','collation','collect','columnar','columns','column_authorization_indicator',
   'column_auth_indicator','column_stats','commit','committed','common','common_data_map','compact',
   'compatibility','compile','complete','compliance','component','components','compose','composite',
   'composite_limit','compound','computation','compute','concat','condition','conditional','confirm',
   'conforming','connect_by_cb_whr_only','connect_by_combine_sw','connect_by_cost_based','connect_by_elim_dups',
   'connect_by_filtering','connect_by_iscycle','connect_by_isleaf','connect_by_root','connect_time','consider',
   'consistent','const','constant','constraint','constraints','container','containers','containers_default',
   'container_data','container_data_admit_null','container_map','container_map_object','content','contents',
   'context','continue','controlfile','conversion','convert','con_dbid_to_id','con_guid_to_id','con_id',
   'con_id_filter','con_id_to_con_name','con_id_to_dbid','con_name_to_id','con_uid_to_id','cookie','copy','corr',
   'corruption','corrupt_xid','corrupt_xid_all','corr_k','corr_s','cos','cosh','cost','cost_xml_query_rewrite',
   'count','covar_pop','covar_samp','co_auth_ind','cpu_costing','cpu_count','cpu_per_call','cpu_per_session',
   'crash','create_file_dest','create_stored_outlines','creation','credential','credentials','critical','cross',
   'crossedition','csconvert','cube','cube_aj','cube_gb','cube_sj','cume_dist','cume_distm','currentv',
   'current_date','current_instance','current_schema','current_time','current_timestamp','current_user',
   'cursor','cursor_sharing_exact','cursor_specific_segment','cv','cycle','d','dangling','data','database',
   'datafile','datafiles','datamovement','dataobjno','dataobj_to_mat_partition','dataobj_to_partition','datapump',
   'datastore','data_link_dml','data_security_rewrite_limit','data_validate','date_mode','day','days','dba',
   'dba_recyclebin','dbms_stats','dbtimezone','db_role_change','db_unique_name','db_version','ddl','deallocate',
   'debug','debugger','dec','declare','decode','decompose','decompress','decorrelate','decr','decrement',
   'decrypt','deduplicate','defaults','default_collation','default_pdb_hint','deferrable','deferred','define',
   'defined','definer','definition','degree','delay','delegate','deletexml','delete_all','demand','dense_rank',
   'dense_rankm','dependent','depth','dequeue','deref','deref_no_rewrite','descendant','description','destroy',
   'detached','determined','determines','deterministic','dg_gather_stats','dictionary','digest','dimension',
   'dimensions','directory','direct_load','direct_path','disable','disable_all','disable_containers_default',
   'disable_container_map','disable_parallel_dml','disable_preset','disable_rpke','disallow','disassociate',
   'discard','disconnect','disk','diskgroup','disks','dismount','distinguished','distribute','distributed',
   'dist_agg_prollup_pushdown','dml','dml_update','docfidelity','document','domain_index_filter',
   'domain_index_no_sort','domain_index_sort','double','downgrade','driving_site','drop_column','drop_group',
   'dst_upgrade_insert_conv','dump','duplicate','duplicated','dv','dynamic','dynamic_sampling',
   'dynamic_sampling_est_cdn','e','each','edition','editionable','editioning','editions','element',
   'eliminate_join','eliminate_oby','eliminate_outer_join','eliminate_sq','elim_groupby','em','empty',
   'empty_blob','empty_clob','enable','enable_all','enable_parallel_dml','enable_preset','encode','encoding',
   'encrypt','encryption','end','end_outline_data','enforce','enforced','enqueue','enterprise','entityescaping',
   'entry','equipart','error','errors','error_argument','error_on_overlap_time','escape','estimate','eval',
   'evalname','evaluate','evaluation','events','every','except','exceptions','exchange','exclude','excluding',
   'execute','exempt','existing','existsnode','exp','expand_gset_to_union','expand_table','expire','explain',
   'explosion','export','express','expr_corr_check','extend','extended','extends','extent','extents','external',
   'externally','extra','extract','extractclobxml','extractvalue','facility','fact','factor','factorize_join',
   'failed','failed_login_attempts','failgroup','failover','failure','false','family','far','fast','fbtscan',
   'feature','feature_compare','feature_details','feature_id','feature_set','feature_value','federation','fetch',
   'filegroup','filesystem_like_logging','file_name_convert','filter','final','fine','finish','first','firstm',
   'first_rows','first_value','fixed_view_data','flagger','flashback','flash_cache','flex','flob','floor','flush',
   'folder','following','follows','force','force_spatial','force_xml_query_rewrite','foreign','forever','format',
   'forward','fragment_number','free','freelist','freelists','freepools','fresh','fresh_mv','from_tz','full',
   'full_outer_join_to_outer','function','functions','g','gather_optimizer_statistics','gather_plan_statistics',
   'gby_conc_rollup','gby_pushdown','generated','get','global','globally','global_name','global_topic_enabled',
   'granted','granular','greatest','grouping','grouping_id','groups','group_by','group_id','guarantee',
   'guaranteed','guard','h','half_years','hash','hashkeys','hash_aj','hash_sj','header','heap','help',
   'hextoraw','hextoref','hidden','hide','hierarchical','hierarchies','hierarchy','hier_ancestor','hier_caption',
   'hier_child_count','hier_column','hier_depth','hier_description','hier_has_children','hier_lag','hier_lead',
   'hier_level','hier_member_name','hier_member_unique_name','hier_order','hier_parent','hier_window','high',
   'hintset_begin','hintset_end','host','hot','hour','hours','http','hwm_brokered','hybrid','id','identifier',
   'identity','idgenerators','idle_time','if','ignore','ignore_optim_embedded_hints','ignore_row_on_dupkey_index',
   'ignore_where_clause','ilm','impact','import','inactive','inactive_account_time','include','includes',
   'include_version','including','incr','incremental','indent','indexed','indexes','indexing','indextype',
   'indextypes','index_asc','index_combine','index_desc','index_ffs','index_filter','index_join','index_rows',
   'index_rrs','index_rs','index_rs_asc','index_rs_desc','index_scan','index_skip_scan','index_ss','index_ss_asc',
   'index_ss_desc','index_stats','indicator','infinite','informational','inherit','initcap','initialized',
   'initially','initrans','inline','inline_xmltype_nt','i

Tagged: