11 Replies Latest reply on Dec 5, 2019 6:48 PM by thatJeffSmith-Oracle

    Sql Developer Freezes when searching in Arabic for a specific field

    ProALiOnLine

      Hi

      I have used more than one version of your wonderful program

      But there is a problem

      It is when you open any table containing data in Arabic and choose the data field and enter the search for a word in Arabic for a specific field appears data normally

      But about doing this research again, the program freezes completely

      So please help me either change the settings or solve this problem

      Thank you

       

      2019-12-04_215256.png

        • 1. Re: Sql Developer Freezes when searching in Arabic for a specific field
          thatJeffSmith-Oracle

          can you provide a sample table with similar data?

           

          and version of oracle database?

          • 2. Re: Sql Developer Freezes when searching in Arabic for a specific field
            Glen Conway

            It might also help to see if the hang occurs waiting for the DB to respond with a result set or during rendering of the result in the object browser.  Open the Statement Log before adding the filter, as in my test case:

            Capture.JPG

            The statement at Sequence 60 is the default Data tab query, while Sequence 62 is the filtered query.

            • 3. Re: Sql Developer Freezes when searching in Arabic for a specific field
              ProALiOnLine

              Thanks for the quick answer

              These are the data

               

              CREATE TABLE UNPAID

                 ( UPD_NO NUMBER(8,0) NOT NULL ENABLE,

              UPD_DATE DATE NOT NULL ENABLE,

              UPD_TYPE NUMBER(3,0),

              UPD_LOCAT VARCHAR2(70 BYTE),

              UPD_TIME DATE,

              UPD_AMONT NUMBER(7,0),

              UPD_NAME VARCHAR2(70 BYTE),

              UPD_POSIT NUMBER(3,0),

              UPD_CAR_NO VARCHAR2(8 BYTE) NOT NULL ENABLE,

              UPD_CAR_TYPE NUMBER(3,0) NOT NULL ENABLE,

              UPD_CAR_REGY NUMBER(3,0) NOT NULL ENABLE,

              UPD_IN_DATE DATE NOT NULL ENABLE,

              UPD_IN_USER NUMBER(5,0),

              MUH NUMBER(2,0) NOT NULL ENABLE

                 )

               

               

               

               

               

               

               

               

               

              --------------------------------------------------------

              --  File created - الأربعاء-ديسمبر-04-2019  

              --------------------------------------------------------

              REM INSERTING into UNPAID

              SET DEFINE OFF;

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77178,to_date('03/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'295717',1,1,to_date('06/12/04','DD/MM/RR'),10,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71811,to_date('20/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'331745',1,1,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77173,to_date('03/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'133457',1,1,to_date('06/12/04','DD/MM/RR'),10,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71849,to_date('23/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'12488',1,1,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193027,to_date('05/12/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'131507',1,1,to_date('12/01/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193033,to_date('07/12/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'24910',1,1,to_date('12/01/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (46861,to_date('02/10/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'جاسم محمد',1,'218650',1,1,to_date('12/12/04','DD/MM/RR'),16,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (191339,to_date('08/07/04','DD/MM/RR'),1,'بابل/تقاطع الكهرباء',null,30000,'غير معروف',null,'62926',1,1,to_date('19/12/04','DD/MM/RR'),32,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71830,to_date('21/07/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'43984',1,1,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (69089,to_date('12/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'ابراهيم نجم عبدالله',2,'54970',1,1,to_date('29/11/04','DD/MM/RR'),23,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549788,to_date('23/11/05','DD/MM/RR'),11,'الشورجة/الكهرباء/جسر المشاة/الخلاني /الوثبة',null,20000,'زيدان خليف',6,'232351',1,1,to_date('18/12/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (552300,to_date('21/12/05','DD/MM/RR'),11,'الشورجة/جسر المشاة/الكهرباء/الرهون/الرصافي',null,20000,'زيدان خليف',6,'255643',1,1,to_date('09/01/06','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549380,to_date('19/11/05','DD/MM/RR'),11,'الشورجة/الكهرباء',null,20000,'زيدان خليف',6,'331845',1,1,to_date('29/11/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (290040,to_date('04/03/05','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'مصطفى محمود',3,'189483',1,1,to_date('20/03/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (271109,to_date('08/02/05','DD/MM/RR'),11,'الشورجة-/الكهرباء',null,20000,'زياد جلال',4,'202336',1,1,to_date('28/02/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716296,to_date('08/04/06','DD/MM/RR'),11,'الشورخه  الكهرباء',null,20000,'   حسام   طالب',2,'318478',1,1,to_date('19/04/06','DD/MM/RR'),58,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (971756,to_date('23/04/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام',2,'170174',1,1,to_date('15/05/06','DD/MM/RR'),14,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716256,to_date('30/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'3291',1,1,to_date('03/09/06','DD/MM/RR'),93,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (682902,to_date('18/02/06','DD/MM/RR'),11,'شارع الخلفاء /كهرباء /الشورجة',null,20000,'حسام طالب',1,'165285',1,1,to_date('13/03/06','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (716269,to_date('01/04/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'228868',1,1,to_date('18/07/06','DD/MM/RR'),62,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (494287,to_date('10/10/11','DD/MM/RR'),11,'الاسكان/مقابل دائر كهرباءالكرخ',null,20000,'باسم جاسم',5,'244968',1,1,to_date('27/10/11','DD/MM/RR'),197,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134511,to_date('17/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'230794',1,1,to_date('03/07/12','DD/MM/RR'),259,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134532,to_date('21/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'46366',1,1,to_date('03/07/12','DD/MM/RR'),259,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (134547,to_date('21/06/12','DD/MM/RR'),11,'مقابل كهرباء الكرخ',null,20000,'باسم جاسم',5,'116297',1,1,to_date('03/07/12','DD/MM/RR'),259,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499118,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'87757ي',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499145,to_date('04/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'82684ي',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499814,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'183208',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499820,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'64211ه',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499827,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'51263ف',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499834,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'71704ر',1,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (191149,to_date('27/11/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد صلاح',4,'9552',2,1,to_date('13/12/04','DD/MM/RR'),15,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (75550,to_date('29/07/04','DD/MM/RR'),11,'كهرباء الشورجه',null,20000,'حسام طالب',1,'47275',2,1,to_date('06/12/04','DD/MM/RR'),5,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71836,to_date('23/06/04','DD/MM/RR'),11,'كهرباءالشورجة/الجمهوري/السنك',null,20000,'ابراهيم نجم',2,'8851',2,1,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193013,to_date('30/11/04','DD/MM/RR'),11,'الشورجة /الكهرباء',null,20000,'زياد جلال',4,'11094',2,1,to_date('12/01/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (18959,to_date('12/03/05','DD/MM/RR'),11,'  الشورجة - الكهرباء',null,20000,'زياد جلال',4,'8487',2,1,to_date('14/04/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (669146,to_date('17/08/06','DD/MM/RR'),1,'تقاطع الكهرباء بابل',null,30000,'1',1,'46279',2,1,to_date('03/09/06','DD/MM/RR'),12,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (280251,to_date('12/02/05','DD/MM/RR'),11,'الشورجه الكهرباء',null,20000,'زيادجلال',4,'69767',2,1,to_date('15/03/05','DD/MM/RR'),56,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (494285,to_date('10/10/11','DD/MM/RR'),11,'الاسكان/مقابل دائر كهرباءالكرخ',null,20000,'باسم جاسم',5,'59439',2,1,to_date('27/10/11','DD/MM/RR'),197,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499144,to_date('04/10/16','DD/MM/RR'),11,'سيطرو الكهرباء',null,20000,'احمد جلال',2,'50306ج',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499103,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'165512',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499104,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'32375ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499108,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'1118',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499113,to_date('01/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'25140ه',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499114,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'5143د',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499116,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'8034ا',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499119,to_date('01/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'135186',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499133,to_date('03/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'7225د',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499825,to_date('08/10/16','DD/MM/RR'),12,'سيطرة الكهرباء',null,20000,'احمد جلال',2,'42369ج',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499829,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'16112ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499839,to_date('09/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'11694ط',2,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (683835,to_date('14/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'38488',3,1,to_date('30/04/06','DD/MM/RR'),57,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (683862,to_date('09/03/06','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',2,'52523',3,1,to_date('29/03/06','DD/MM/RR'),89,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (77169,to_date('02/08/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'79547',3,1,to_date('06/12/04','DD/MM/RR'),10,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (609334,to_date('24/01/06','DD/MM/RR'),11,'كهرباء  الشورجه',null,20000,'حسام   طالب',2,'21327',3,1,to_date('14/02/06','DD/MM/RR'),58,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499836,to_date('08/10/16','DD/MM/RR'),2,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'54121و',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499844,to_date('09/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'58078ط',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499848,to_date('09/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'38324',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499805,to_date('06/10/16','DD/MM/RR'),17,'سيطرة الكهرباء',null,15000,'احمد جلال',2,'41419',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499809,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'59958ط',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499817,to_date('06/10/16','DD/MM/RR'),1,'سيطرة الكهرباء',null,30000,'احمد جلال',2,'5464ر',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499105,to_date('01/10/16','DD/MM/RR'),17,'سيطرو الكهرباء',null,15000,'احمد جلال',2,'64018',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499122,to_date('02/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'18441',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499140,to_date('03/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'50391و',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499142,to_date('04/10/16','DD/MM/RR'),11,'سيطرو الكهرباء',null,20000,'احمد جلال',2,'5847ج',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499143,to_date('04/10/16','DD/MM/RR'),1,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'610',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (2499150,to_date('04/10/16','DD/MM/RR'),2,'سيطرو الكهرباء',null,30000,'احمد جلال',2,'61860',3,1,to_date('23/10/16','DD/MM/RR'),362,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70807,to_date('13/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70848,to_date('17/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73355,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73372,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73400,to_date('25/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70837,to_date('16/07/04','DD/MM/RR'),11,'الكهرباء/الشورجة',null,20000,'ابراهيم نجم',2,'162',8,9,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73365,to_date('23/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73387,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73388,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73385,to_date('24/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73386,to_date('24/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'105748',7,1,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71838,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73371,to_date('23/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'7359',8,7,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73367,to_date('23/07/04','DD/MM/RR'),11,'كهرباء الشورجة',null,20000,'حسام طالب',1,'232355',7,1,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193041,to_date('09/12/04','DD/MM/RR'),0,'الشورجة /الكهرباء',null,null,'زياد جلال',4,'9999999',999,999,to_date('12/01/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70834,to_date('15/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70816,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70819,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70821,to_date('14/07/04','DD/MM/RR'),11,'الكهرباء/الشورجة',null,20000,'ابراهيم نجم',2,'72589',7,1,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70823,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70824,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71843,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70829,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (70830,to_date('14/07/04','DD/MM/RR'),0,'الكهرباء/الشورجة',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('29/11/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (69083,to_date('10/07/04','DD/MM/RR'),11,'كهرباء الشورجة',to_date('01/11/04','DD/MM/RR'),20000,'ابراهيم نجم عبدالله',2,'1345',7,2,to_date('17/01/05','DD/MM/RR'),31,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (193001,to_date('28/11/04','DD/MM/RR'),0,'الشورجة /الكهرباء',null,null,'زياد جلال',4,'9999999',999,999,to_date('12/01/05','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (73391,to_date('25/07/04','DD/MM/RR'),0,'كهرباء الشورجة',null,null,'حسام طالب',1,'9999999',999,999,to_date('21/11/04','DD/MM/RR'),20,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (71840,to_date('23/07/04','DD/MM/RR'),0,'كهرباءالشورجة/الجمهوري/السنك',null,null,'ابراهيم نجم',2,'9999999',999,999,to_date('04/12/04','DD/MM/RR'),13,1);

              Insert into UNPAID (UPD_NO,UPD_DATE,UPD_TYPE,UPD_LOCAT,UPD_TIME,UPD_AMONT,UPD_NAME,UPD_POSIT,UPD_CAR_NO,UPD_CAR_TYPE,UPD_CAR_REGY,UPD_IN_DATE,UPD_IN_USER,MUH) values (549771,to_date('21/11/05','DD/MM/RR'),0,'الشورجة/الكهرباء',null,null,'زيدان خليف',6,'9999999',999,999,to_date('29/11/05','DD/MM/RR'),20,1);

              • 4. Re: Sql Developer Freezes when searching in Arabic for a specific field
                ProALiOnLine

                I'll do it and try

                May the problem be solved

                Thank you

                • 7. Re: Sql Developer Freezes when searching in Arabic for a specific field
                  Glen Conway

                  I took your table definition and the first two lines of data as a test case, running the DDL and the two INSERTS, then committing the rows.

                   

                  Next, in the Object Viewer, I filtered on each of the two UPD_LOCAT arabic values using the "=" operator rather than "LIKE", closing the object viewer after each attempt. All seemed to work fine.

                   

                  But then I decided to use the Filter input box's LOV to select one of the predicates I had previously entered.  Interestingly, after running the first one, I tried to edit the arabic string in the Filter input box.  The focus was after the right-most single-quote of the predicate.  Eureka!  A (destructive) backspace from the end of the predicate, rather than moving (and destroying) the character one space to the left, jumps all the way to the left single-quote without destroying any of the arabic characters.  And hangs SQL Developer.

                   

                  Here is a jstack:

                  2019-12-04 14:52:10
                  Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.221-b11 mixed mode):
                  
                  
                  "Background Parser#2" #330 prio=6 os_prio=0 tid=0x000000002b5a0000 nid=0x4ec waiting on condition [0x000000001fc6f000]
                    java.lang.Thread.State: TIMED_WAITING (sleeping)
                  at java.lang.Thread.sleep(Native Method)
                  at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)
                  at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "RaptorTaskThread10" #297 prio=5 os_prio=0 tid=0x0000000029f4d000 nid=0x56d8 waiting on condition [0x000000001c83e000]
                    java.lang.Thread.State: WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x0000000082230b40> (a java.util.concurrent.SynchronousQueue$TransferStack)
                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                  at java.util.concurrent.SynchronousQueue$TransferStack.awaitFulfill(SynchronousQueue.java:458)
                  at java.util.concurrent.SynchronousQueue$TransferStack.transfer(SynchronousQueue.java:362)
                  at java.util.concurrent.SynchronousQueue.take(SynchronousQueue.java:924)
                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
                  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Image Animator 3" #116 daemon prio=3 os_prio=-1 tid=0x0000000025518800 nid=0x1fe0 waiting on condition [0x000000002871e000]
                    java.lang.Thread.State: TIMED_WAITING (sleeping)
                  at java.lang.Thread.sleep(Native Method)
                  at sun.awt.image.GifFrame.dispose(GifImageDecoder.java:670)
                  at sun.awt.image.GifImageDecoder.readImage(GifImageDecoder.java:458)
                  at sun.awt.image.GifImageDecoder.produceImage(GifImageDecoder.java:212)
                  at sun.awt.image.InputStreamImageSource.doFetch(InputStreamImageSource.java:269)
                  at sun.awt.image.ImageFetcher.fetchloop(ImageFetcher.java:205)
                  at sun.awt.image.ImageFetcher.run(ImageFetcher.java:169)
                  
                  
                  "Background Parser#1" #85 prio=5 os_prio=0 tid=0x0000000025515800 nid=0x5fbc waiting on condition [0x000000003249f000]
                    java.lang.Thread.State: TIMED_WAITING (sleeping)
                  at java.lang.Thread.sleep(Native Method)
                  at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)
                  at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "status-0" #84 prio=2 os_prio=-2 tid=0x0000000025514000 nid=0x3d00 waiting on condition [0x000000003269f000]
                    java.lang.Thread.State: WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x000000008558b340> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                  at java.util.concurrent.DelayQueue.take(DelayQueue.java:211)
                  at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:338)
                  at oracle.ide.status.StatusExecutor$StatusQueue.take(StatusExecutor.java:300)
                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
                  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "WeakDataReference polling" #82 prio=1 os_prio=-2 tid=0x000000002550f800 nid=0x5934 in Object.wait() [0x000000002ed0f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
                  - locked <0x0000000085574538> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
                  at oracle.ide.util.WeakDataReference$Cleaner.run(WeakDataReference.java:88)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Background Parser#0" #77 prio=6 os_prio=0 tid=0x0000000025511800 nid=0x539c waiting on condition [0x000000003365f000]
                    java.lang.Thread.State: TIMED_WAITING (sleeping)
                  at java.lang.Thread.sleep(Native Method)
                  at oracle.dbtools.raptor.plsql.BackgroundParser$1.construct(BackgroundParser.java:160)
                  at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "TextBufferScavenger" #75 prio=6 os_prio=0 tid=0x0000000025513000 nid=0x5084 in Object.wait() [0x0000000032c3e000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
                  - locked <0x0000000085ec9748> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
                  at oracle.ide.model.FacadeBufferReference$PollingThread.run(FacadeBufferReference.java:145)
                  
                  
                  "oracle.jdbc.driver.BlockSource.ThreadedCachingBlockSource.BlockReleaser" #69 daemon prio=4 os_prio=-1 tid=0x0000000029f49000 nid=0x3f94 in Object.wait() [0x0000000032f3f000]
                    java.lang.Thread.State: TIMED_WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser.run(BlockSource.java:331)
                  - locked <0x00000000847a4688> (a oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource$BlockReleaser)
                  
                  
                  "Timer-3" #68 daemon prio=5 os_prio=0 tid=0x0000000029f48800 nid=0x3eec in Object.wait() [0x0000000032e3f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.TimerThread.mainLoop(Timer.java:526)
                  - locked <0x00000000847a4b50> (a java.util.TaskQueue)
                  at java.util.TimerThread.run(Timer.java:505)
                  
                  
                  "pool-5-thread-1" #64 prio=5 os_prio=0 tid=0x000000002429e800 nid=0x423c waiting on condition [0x000000002ea0e000]
                    java.lang.Thread.State: TIMED_WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x0000000084b76cc8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
                  at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:1093)
                  at java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(ScheduledThreadPoolExecutor.java:809)
                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
                  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "IconOverlayTracker Timer: null-jdbcNodeInfoType" #51 prio=5 os_prio=0 tid=0x0000000024297800 nid=0x5904 in Object.wait() [0x000000003219e000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.TimerThread.mainLoop(Timer.java:526)
                  - locked <0x00000000847a5188> (a java.util.TaskQueue)
                  at java.util.TimerThread.run(Timer.java:505)
                  
                  
                  "Swing-Shell" #45 daemon prio=6 os_prio=0 tid=0x0000000024297000 nid=0x2a14 waiting on condition [0x0000000030a2e000]
                    java.lang.Thread.State: WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x000000008388f910> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                  at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
                  at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
                  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
                  at sun.awt.shell.Win32ShellFolderManager2$ComInvoker$3.run(Win32ShellFolderManager2.java:556)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "WaitCursor-Timer" #43 prio=6 os_prio=0 tid=0x0000000024295800 nid=0x2e90 in Object.wait() [0x000000003092f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.TimerThread.mainLoop(Timer.java:526)
                  - locked <0x000000008388fe18> (a java.util.TaskQueue)
                  at java.util.TimerThread.run(Timer.java:505)
                  
                  
                  "InterruptTimer" #42 daemon prio=5 os_prio=0 tid=0x0000000024299000 nid=0x5338 in Object.wait() [0x00000000302ef000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.TimerThread.mainLoop(Timer.java:526)
                  - locked <0x00000000835086b0> (a java.util.TaskQueue)
                  at java.util.TimerThread.run(Timer.java:505)
                  
                  
                  "Thread-8" #38 daemon prio=5 os_prio=0 tid=0x0000000029f4c000 nid=0x3310 in Object.wait() [0x000000002f8ef000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.prefs.AbstractPreferences$EventDispatchThread.run(AbstractPreferences.java:1482)
                  - locked <0x0000000080578dd0> (a java.util.LinkedList)
                  
                  
                  "ChangeSetService" #36 daemon prio=1 os_prio=-2 tid=0x0000000029f46800 nid=0x3648 in Object.wait() [0x000000002e90f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.awaitEvents(ChangeSetService.java:131)
                  - locked <0x00000000831a2e98> (a oracle.jdevimpl.vcs.changeset.ChangeSetService)
                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.eventLoop(ChangeSetService.java:152)
                  at oracle.jdevimpl.vcs.changeset.ChangeSetService.access$000(ChangeSetService.java:60)
                  at oracle.jdevimpl.vcs.changeset.ChangeSetService$1.run(ChangeSetService.java:99)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Scheduler" #35 daemon prio=5 os_prio=0 tid=0x0000000029f4b800 nid=0x4a6c in Object.wait() [0x000000002ccfe000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at oracle.dbtools.raptor.backgroundTask.TaskLinkedList.takeNextTask(TaskLinkedList.java:47)
                  - locked <0x0000000082230368> (a oracle.dbtools.raptor.backgroundTask.TaskLinkedList)
                  at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$SchedulerThread.run(RaptorTaskManager.java:548)
                  
                  
                  "Log Poller" #34 prio=1 os_prio=-2 tid=0x0000000029f4d800 nid=0x36e4 waiting on condition [0x0000000028bde000]
                    java.lang.Thread.State: WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x0000000081d567a8> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
                  at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
                  at oracle.ide.log.QueuedLoggingHandler.take(QueuedLoggingHandler.java:60)
                  at oracle.ideimpl.log.TabbedLogManager$4.run(TabbedLogManager.java:333)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "TimedCache-Timer" #30 daemon prio=5 os_prio=0 tid=0x0000000024339000 nid=0x3b14 in Object.wait() [0x0000000028adf000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.util.TimerThread.mainLoop(Timer.java:526)
                  - locked <0x0000000081050e30> (a java.util.TaskQueue)
                  at java.util.TimerThread.run(Timer.java:505)
                  
                  
                  "Framework Event Dispatcher" #26 daemon prio=6 os_prio=0 tid=0x0000000024335000 nid=0x43dc in Object.wait() [0x00000000261ce000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.getNextEvent(EventManager.java:400)
                  - locked <0x00000000804839f8> (a org.eclipse.osgi.framework.eventmgr.EventManager$EventThread)
                  at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:336)
                  
                  
                  "State Data Manager" #24 daemon prio=5 os_prio=0 tid=0x0000000024336000 nid=0x211c waiting on condition [0x0000000024dff000]
                    java.lang.Thread.State: TIMED_WAITING (sleeping)
                  at java.lang.Thread.sleep(Native Method)
                  at org.eclipse.osgi.internal.baseadaptor.StateManager.run(StateManager.java:297)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Framework Active Thread" #23 prio=5 os_prio=0 tid=0x0000000024334800 nid=0x6120 in Object.wait() [0x0000000024cff000]
                    java.lang.Thread.State: TIMED_WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at org.eclipse.osgi.framework.internal.core.Framework.run(Framework.java:1870)
                  - locked <0x00000000805d5228> (a org.eclipse.osgi.framework.internal.core.Framework)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Active Reference Queue Daemon" #19 daemon prio=1 os_prio=-2 tid=0x000000001baf9000 nid=0x29dc in Object.wait() [0x000000001db1f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
                  - locked <0x00000000805db0e8> (a java.lang.ref.ReferenceQueue$Lock)
                  at org.openide.util.lookup.implspi.ActiveQueue$Impl.removeSuper(ActiveQueue.java:93)
                  at org.openide.util.lookup.implspi.ActiveQueue$Daemon.run(ActiveQueue.java:131)
                  
                  
                  "TimerQueue" #17 daemon prio=5 os_prio=0 tid=0x000000001b8f5800 nid=0x2330 waiting on condition [0x000000001ce1e000]
                    java.lang.Thread.State: TIMED_WAITING (parking)
                  at sun.misc.Unsafe.park(Native Method)
                  - parking to wait for  <0x000000008046ce28> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
                  at java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
                  at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
                  at java.util.concurrent.DelayQueue.take(DelayQueue.java:223)
                  at javax.swing.TimerQueue.run(TimerQueue.java:174)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "AWT-EventQueue-0" #16 prio=6 os_prio=0 tid=0x000000001b81c000 nid=0x40a0 runnable [0x000000001c46c000]
                    java.lang.Thread.State: RUNNABLE
                  at javax.swing.text.BoxView.updateLayoutArray(BoxView.java:211)
                  at javax.swing.text.BoxView.replace(BoxView.java:190)
                  at javax.swing.text.View.append(View.java:417)
                  at javax.swing.text.FlowView$FlowStrategy.layout(FlowView.java:473)
                  at javax.swing.text.TextLayoutStrategy.layout(TextLayoutStrategy.java:110)
                  at javax.swing.text.FlowView.layout(FlowView.java:201)
                  at javax.swing.text.BoxView.setSize(BoxView.java:397)
                  at javax.swing.plaf.basic.BasicTextUI$RootView.setSize(BasicTextUI.java:1722)
                  at javax.swing.plaf.basic.BasicTextUI.modelToView(BasicTextUI.java:1046)
                  at javax.swing.plaf.basic.BasicTextUI.modelToView(BasicTextUI.java:1022)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler.updateInsight(CompletionPopupHandler.java:701)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler.access$1400(CompletionPopupHandler.java:80)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler$CaretHandler.caretUpdate(CompletionPopupHandler.java:887)
                  at javax.swing.text.JTextComponent.fireCaretUpdate(JTextComponent.java:397)
                  at javax.swing.text.JTextComponent$MutableCaretEvent.fire(JTextComponent.java:4394)
                  at javax.swing.text.JTextComponent$MutableCaretEvent.stateChanged(JTextComponent.java:4416)
                  at javax.swing.text.DefaultCaret.fireStateChanged(DefaultCaret.java:802)
                  at javax.swing.text.DefaultCaret.changeCaretPosition(DefaultCaret.java:1274)
                  at javax.swing.text.DefaultCaret.handleSetDot(DefaultCaret.java:1173)
                  at javax.swing.text.DefaultCaret.setDot(DefaultCaret.java:1154)
                  at javax.swing.text.DefaultCaret$Handler.insertUpdate(DefaultCaret.java:1723)
                  at javax.swing.text.AbstractDocument.fireInsertUpdate(AbstractDocument.java:201)
                  at javax.swing.text.AbstractDocument.handleInsertString(AbstractDocument.java:748)
                  at javax.swing.text.AbstractDocument.insertString(AbstractDocument.java:707)
                  at javax.swing.text.PlainDocument.insertString(PlainDocument.java:130)
                  at oracle.dbtools.raptor.controls.grid.GridFilterInsightProvider.completeInsight(GridFilterInsightProvider.java:73)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler.completeInsight(CompletionPopupHandler.java:815)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler.access$1200(CompletionPopupHandler.java:80)
                  at oracle.javatools.controls.completionfield.CompletionPopupHandler$CompleteInsightAction.actionPerformed(CompletionPopupHandler.java:833)
                  at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1668)
                  at javax.swing.JComponent.processKeyBinding(JComponent.java:2882)
                  at javax.swing.JComponent.processKeyBindings(JComponent.java:2929)
                  at javax.swing.JComponent.processKeyEvent(JComponent.java:2845)
                  at java.awt.Component.processEvent(Component.java:6316)
                  at java.awt.Container.processEvent(Container.java:2239)
                  at java.awt.Component.dispatchEventImpl(Component.java:4889)
                  at java.awt.Container.dispatchEventImpl(Container.java:2297)
                  at java.awt.Component.dispatchEvent(Component.java:4711)
                  at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954)
                  at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:835)
                  at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1103)
                  at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:974)
                  at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:800)
                  at java.awt.Component.dispatchEventImpl(Component.java:4760)
                  at java.awt.Container.dispatchEventImpl(Container.java:2297)
                  at java.awt.Window.dispatchEventImpl(Window.java:2746)
                  at java.awt.Component.dispatchEvent(Component.java:4711)
                  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
                  at java.awt.EventQueue.access$500(EventQueue.java:97)
                  at java.awt.EventQueue$3.run(EventQueue.java:709)
                  at java.awt.EventQueue$3.run(EventQueue.java:703)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
                  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
                  at java.awt.EventQueue$4.run(EventQueue.java:733)
                  at java.awt.EventQueue$4.run(EventQueue.java:731)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
                  at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
                  at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
                  at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
                  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
                  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
                  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
                  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
                  at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
                  
                  
                  "AWT-Windows" #14 daemon prio=6 os_prio=0 tid=0x000000001b82d000 nid=0x3f64 runnable [0x000000001c36f000]
                    java.lang.Thread.State: RUNNABLE
                  at sun.awt.windows.WToolkit.eventLoop(Native Method)
                  at sun.awt.windows.WToolkit.run(WToolkit.java:315)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "AWT-Shutdown" #13 prio=5 os_prio=0 tid=0x000000001b82c000 nid=0x5a84 in Object.wait() [0x000000001c26f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at sun.awt.AWTAutoShutdown.run(AWTAutoShutdown.java:295)
                  - locked <0x0000000080482e50> (a java.lang.Object)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Java2D Disposer" #12 daemon prio=10 os_prio=2 tid=0x000000001b82b800 nid=0x63a0 in Object.wait() [0x000000001c16f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
                  - locked <0x0000000080580908> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
                  at sun.java2d.Disposer.run(Disposer.java:148)
                  at java.lang.Thread.run(Thread.java:748)
                  
                  
                  "Service Thread" #10 daemon prio=9 os_prio=0 tid=0x000000001a8ff800 nid=0x5d20 runnable [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "C1 CompilerThread3" #9 daemon prio=9 os_prio=2 tid=0x000000001a86f000 nid=0x3194 waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "C2 CompilerThread2" #8 daemon prio=9 os_prio=2 tid=0x000000001a867000 nid=0x31fc waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "C2 CompilerThread1" #7 daemon prio=9 os_prio=2 tid=0x000000001a865000 nid=0x13e0 waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "C2 CompilerThread0" #6 daemon prio=9 os_prio=2 tid=0x000000001a863000 nid=0x518 waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "Attach Listener" #5 daemon prio=5 os_prio=2 tid=0x000000001a861800 nid=0x4948 waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "Signal Dispatcher" #4 daemon prio=9 os_prio=2 tid=0x0000000018a5e800 nid=0x2044 runnable [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "Finalizer" #3 daemon prio=8 os_prio=1 tid=0x000000001a851000 nid=0x5410 in Object.wait() [0x000000001ae2e000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
                  - locked <0x00000000805f90a0> (a java.lang.ref.ReferenceQueue$Lock)
                  at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:165)
                  at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:216)
                  
                  
                  "Reference Handler" #2 daemon prio=10 os_prio=2 tid=0x0000000018a4d000 nid=0x6348 in Object.wait() [0x000000001ad2f000]
                    java.lang.Thread.State: WAITING (on object monitor)
                  at java.lang.Object.wait(Native Method)
                  at java.lang.Object.wait(Object.java:502)
                  at java.lang.ref.Reference.tryHandlePending(Reference.java:191)
                  - locked <0x00000000804dc2e0> (a java.lang.ref.Reference$Lock)
                  at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:153)
                  
                  
                  "main" #1 prio=5 os_prio=0 tid=0x00000000038e8000 nid=0x61fc waiting on condition [0x0000000000000000]
                    java.lang.Thread.State: RUNNABLE
                  
                  
                  "VM Thread" os_prio=2 tid=0x0000000018a45800 nid=0x1fdc runnable
                  
                  
                  "GC task thread#0 (ParallelGC)" os_prio=0 tid=0x00000000038fc800 nid=0x1b30 runnable
                  
                  
                  "GC task thread#1 (ParallelGC)" os_prio=0 tid=0x00000000038fe000 nid=0x5ae8 runnable
                  
                  
                  "GC task thread#2 (ParallelGC)" os_prio=0 tid=0x00000000038ff800 nid=0x15c4 runnable
                  
                  
                  "GC task thread#3 (ParallelGC)" os_prio=0 tid=0x0000000003901800 nid=0x540 runnable
                  
                  
                  "GC task thread#4 (ParallelGC)" os_prio=0 tid=0x0000000003904000 nid=0x42dc runnable
                  
                  
                  "GC task thread#5 (ParallelGC)" os_prio=0 tid=0x0000000003905000 nid=0x2f74 runnable
                  
                  
                  "GC task thread#6 (ParallelGC)" os_prio=0 tid=0x0000000003908000 nid=0x4768 runnable
                  
                  
                  "GC task thread#7 (ParallelGC)" os_prio=0 tid=0x0000000003909800 nid=0x9d8 runnable
                  
                  
                  "VM Periodic Task Thread" os_prio=2 tid=0x000000001a91a800 nid=0x2864 waiting on condition
                  
                  
                  JNI global references: 3491
                  
                  
                  • 8. Re: Sql Developer Freezes when searching in Arabic for a specific field
                    Glen Conway

                    Just to add some context, this was using SQL Developer 19.2.1 against an 11g XE DB with an installed NLS_CHARACTERSET of AL32UTF8.

                     

                    So, basically, it works fine if I copy/paste an Arabic text string into the Filter input field, but any attempt to edit the Arabic within the input field results in a hang.

                    • 9. Re: Sql Developer Freezes when searching in Arabic for a specific field
                      thatJeffSmith-Oracle

                      thanks for all the info, I have logged a bug

                      • 10. Re: Sql Developer Freezes when searching in Arabic for a specific field
                        ProALiOnLine

                        Thanks for discovering the main problem

                        And make that effort

                        So will this problem be solved in the next version ??

                        I repeat my thanks and appreciation to you

                         

                        • 11. Re: Sql Developer Freezes when searching in Arabic for a specific field
                          thatJeffSmith-Oracle

                          It's too late for both 19.3 and 19.4, hopefully for 20.1