Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Bug, htp(), miss charachter, AL32UTF8

2011-09-08
2013-05-28
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    I have same experience already reported in topic "Urgent Bug, htp()" I give a further example
    Error happens with NLS_CHARACTERSET AL32UTF8, I have tested this example with WE8ISO8859P1 too, and I have no error.

    select * from v$nls_parameters where parameter='NLS_CHARACTERSET'; 
    NLS_CHARACTERSET AL32UTF8
    

    Please install next simulation in a schema where json already installed is
    Simulation builds two Tables:  TAB_PERSONEN, TAB_DV_X_MONATEN and a Procedure: PRODUCE_JSON_WITH_ERROR

     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    prompt CREATE TABLE TAB_DV_X_MONATEN
    CREATE TABLE "TAB_DV_X_MONATEN"
       (    "DIENSTVERHAELTNIS_ID" NUMBER(*,0),
        "MONATS_AUFZEICHNUNG_ID" NUMBER(*,0),
        "MONAT_MM" NUMBER,
        "MONAT_YYYY" VARCHAR2(4),
        "STATUS_MONAT_ID" NUMBER(*,0),
        "STATUS_MONAT_KB" VARCHAR2(20),
        "STATUS_MONAT_NAME_LANG" VARCHAR2(255),
        "IS_MONAT_4_RO_LOCKED" VARCHAR2(4000)
       ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
      TABLESPACE "USERS"
    /
    prompt CREATE TABLE TAB_PERSONEN
    CREATE TABLE "TAB_PERSONEN"
       (    "DIENSTVERHAELTNIS_ID" NUMBER(*,0) NOT NULL ENABLE,
        "ORG_EINHEIT_ID" NUMBER(*,0) NOT NULL ENABLE,
        "ORG_EINHEIT_NAME_KURZ" VARCHAR2(255),
        "DV_GUELTIG_FLAG" CHAR(1) NOT NULL ENABLE,
        "PERSON_ID" NUMBER(*,0),
        "FAMILIENNAME" VARCHAR2(255),
        "VORNAME" VARCHAR2(255),
        "QKENNUNG" VARCHAR2(6),
        "PERSON_GUELTIG_FLAG" CHAR(1),
        "PERSON_TEST_FLAG" CHAR(1)
       ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
      TABLESPACE "USERS"
    /
    
     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    prompt LT_Init TAB_PERSONEN (insert)
    -- Environment mit dem diesen File geschrieben wurde:
    -- NLS_LANG=GERMAN_GERMANY.AL32UTF8
    ALTER SESSION SET NLS_LANGUAGE = 'GERMAN';
    ALTER SESSION SET NLS_DATE_FORMAT = 'DD.MM.YYYY HH24:MI:SS';
    ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF';
    ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF TZH:TZM';
    set define off
    /*   No Contraints Arrangement noetig!   */
    /*   Delete und wieder Insert   */
    delete "TAB_PERSONEN";
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('223','109','Anästhesie & Intensivmedizin','J','165','Puuu','Güuuuuu','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('228','102','Herzchirurgie','J','159','Müluur','Luuuuu','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('240','109','Anästhesie & Intensivmedizin','J','173','Schuuuur','Andreas','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('242','105','Unfallchirurgie','J','167','Rauuuuu','Christoph','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('243','104','Plastische, Rekonstruktive & Ästhetische Chirurgie','J','176','Schoeluuu','Thomas','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('245','104','Plastische, Rekonstruktive & Ästhetische Chirurgie','J','177','Schwabuuuuu','Anton','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('251','106','Urologie','J','166','Raduuuu','Christian','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('271','109','Anästhesie & Intensivmedizin','J','179','Strohuuuuuu','Hans-Ulrich','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('272','105','Unfallchirurgie','J','150','Luuu','Maruuu','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('276','102','Herzchirurgie','J','169','Ruuuuuuu-Ulmer','Elfruuuu','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('277','109','Anästhesie & Intensivmedizin','J','155','Mittuuuuuu','Markus','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('305','105','Unfallchirurgie','J','168','Rosuuuuuuuu','Ruuu','','J','N');
    insert into "TAB_PERSONEN" (DIENSTVERHAELTNIS_ID,ORG_EINHEIT_ID,ORG_EINHEIT_NAME_KURZ,DV_GUELTIG_FLAG,PERSON_ID,FAMILIENNAME,VORNAME,QKENNUNG,PERSON_GUELTIG_FLAG,PERSON_TEST_FLAG) 
                                  values ('316','102','Herzchirurgie','J','-3','CuuuuuTest','JoseTest','q0-3mm','J','L');
    set define on
    
     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    prompt LT_Init TAB_DV_X_MONATEN (insert)
    -- Environment mit dem diesen File geschrieben wurde:
    -- NLS_LANG=GERMAN_GERMANY.AL32UTF8
    ALTER SESSION SET NLS_LANGUAGE = 'GERMAN';
    ALTER SESSION SET NLS_DATE_FORMAT = 'DD.MM.YYYY HH24:MI:SS';
    ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF';
    ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF TZH:TZM';
    set define off
    /*   No Contraints Arrangement noetig!   */
    /*   Delete und wieder Insert   */
    delete "TAB_DV_X_MONATEN";
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','99','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','100','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','101','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','102','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('223','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','113','1','2011','11','ARTZ_VER','Verbesserung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','114','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','115','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','116','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('228','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','207','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','208','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','209','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','210','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('240','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','127','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','128','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','129','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','130','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('242','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','225','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','226','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','227','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','228','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('243','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','232','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','233','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','234','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','235','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('245','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','181','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','182','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','183','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','184','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('251','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','239','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','240','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','241','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','242','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('271','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','137','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','138','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','139','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','140','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('272','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','195','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','196','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','197','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','198','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('276','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','165','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','166','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','167','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','168','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('277','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','188','1','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','189','2','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','190','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','191','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('305','','12','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','249','1','2011','14','VR_UEBER','Überprüfung VR','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','250','2','2011','12','OM_UEBER','Überprüfung OM','N');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','251','3','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','252','4','2011','10','ARTZ_AUF','Aufzeichnung Arzt','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','5','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','6','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','7','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','8','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','9','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','10','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','11','','','','','J');
    insert into "TAB_DV_X_MONATEN" (DIENSTVERHAELTNIS_ID,MONATS_AUFZEICHNUNG_ID,MONAT_MM,MONAT_YYYY,STATUS_MONAT_ID,STATUS_MONAT_KB,STATUS_MONAT_NAME_LANG,IS_MONAT_4_RO_LOCKED) 
                                      values ('316','','12','','','','','J');
    set define on
    
     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    prompt  CREATE of PROCEDURE PRODUCE_JSON_WITH_ERROR
    set define off
    CREATE OR REPLACE PROCEDURE "PRODUCE_JSON_WITH_ERROR"
      as
      /*
      param werde constant!!
      */
      p_AccountId number := 5;
      p_Jahr number := 2011;
      p_RolleKBz varchar2(10) := 'RR_OEM';
      p_OrgIdList varchar2(10) := '0';
      p_WithHeader number := 1;
       /*
        */
        --
        -- type um die JSON data zusammen mit einen HEADER zu liefern.
        type COL_LIST_T IS TABLE of varchar2(30)
          index by binary_integer;
        -- variable fuer die Spalte von PersonList (fuer HEADER in JSON output).
        l_ColList1 COL_LIST_T;
        l_ColList2 COL_LIST_T;
        -- json structur, die die gesamte daten zurueck senden wird
        l_JO_ReturnData  json := json();
        /*
          Local variable
        */
        l_RolleId  number := 14;
        /*
          cursor fuer die monatne ein bestimmte Dienstverhaeltnisse und Jahh
            er liefert immer 12 Zeile, eine pro Monat!
        */
        cursor c_GetMonaten(pDV number, pYYYY number, pRolleId number) is
          select MONATS_AUFZEICHNUNG_ID
               , MONAT_MM
               , MONAT_YYYY
               , STATUS_MONAT_ID
               , STATUS_MONAT_KB
               ,  STATUS_MONAT_NAME_LANG
               , IS_MONAT_4_RO_LOCKED
          from   tab_dv_x_monaten xx
          where  xx.DIENSTVERHAELTNIS_ID=pDV
          order by MONAT_MM;
        cursor c_Personen is
          select
             pattern
            ,DIENSTVERHAELTNIS_ID
            ,ORG_EINHEIT_ID
            ,ORG_EINHEIT_NAME_KURZ
            ,DV_GUELTIG_FLAG
            ,PERSON_ID
            ,FAMILIENNAME
            ,VORNAME
            ,QKENNUNG
            ,PERSON_GUELTIG_FLAG
            ,PERSON_TEST_FLAG
          from tab_personen
                   join (select 'test__1' as pattern from dual
                            union
                         select 'test__2' as pattern from dual
                         ) on 1=1
          where 1=1
          order by ORG_EINHEIT_NAME_KURZ,ORG_EINHEIT_ID,FAMILIENNAME,DIENSTVERHAELTNIS_ID;
      begin
        /*
          optional header, nur fuer debug!!?
        */
        if (p_WithHeader = 1) then
          owa_util.mime_header('text/plain', FALSE );
          htp.p('Cache-Control: no-cache');
          htp.p('Pragma: no-cache');
          owa_util.http_header_close;
        end if;
        /*
        Debug
        */
        --RAISE_APPLICATION_ERROR(-20010, 'getStatusUebersichtPerJahrJSON() TESTETS!',true);
        /*
           test RolleID
        if p_RolleKBz is null then
          RAISE_APPLICATION_ERROR(-20010, 'getStatusUebersichtPerJahrJSON() p_RolleKBz darf nich null sein!',true);
        else
          l_RolleId := pkg_personen.getRolleId(p_KBz=>p_RolleKBz);
          if l_RolleId is null then
            RAISE_APPLICATION_ERROR(-20010, 'getStatusUebersichtPerJahrJSON() p_RolleKBz hat ein unbekannte Wert:'||p_RolleKBz,true);
          elsif not PKG_AUTH_4_APEX.hatRolleBool (p_accountId, p_RolleKBz) then
            RAISE_APPLICATION_ERROR(-20010, 'getStatusUebersichtPerJahrJSON() aktuall user hat die eingegebene rolle nicht! p_AccountId:'||p_accountId||', p_RolleKBz:'||p_RolleKBz,true);
          end if;
        end if;
        */
        /*
           Define list of Spalte () soll gliech wie RECORD: GET_PERSONEN_TYP
        */
        declare
          l_cc number :=1;
        begin
          l_ColList1(l_cc) := 'PATTERN';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'ORG_EINHEIT_NAME_KURZ';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'ORG_EINHEIT_ID';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'FAMILIENNAME';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'VORNAME';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'QKENNUNG';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'PERSON_ID';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'PERSON_GUELTIG_FLAG';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'PERSON_TEST_FLAG';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'DIENSTVERHAELTNIS_ID';
          l_cc:=l_cc+1;
          l_ColList1(l_cc) := 'DV_GUELTIG_FLAG';
    --      l_cc:=l_cc+1;
    --      l_ColList1(l_cc) := 'DV_ERSTELLT';
    --      l_cc:=l_cc+1;
    --      l_ColList1(l_cc) := 'DV_DEAKTIVIERT';
        end;
        declare
          l_cc number :=1;
        begin
          l_ColList2(l_cc) := 'MONATS_AUFZEICHNUNG_ID';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'MONAT_MM';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'MONAT_YYYY';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'STATUS_MONAT_ID';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'STATUS_MONAT_KB';
    --      l_cc:=l_cc+1;
    --      l_ColList2(l_cc) := 'STATUS_MONAT_NAME_KURZ';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'STATUS_MONAT_NAME_LANG';
          l_cc:=l_cc+1;
          l_ColList2(l_cc) := 'IS_MONAT_4_RO_LOCKED';
        end;
        /*
           Build Header as JSON OBJ
        */
        declare
          l_JO_Header     json;
          l_StringList1  varchar2(500);
          l_StringList2  varchar2(500);
          l_JA_PersonColList  json_list;
          l_JO_PersonColMap   json;
          l_JA_MonatColList    json_list;
          l_JA_MonatSubColList  json_list;
          l_JO_MonatSubColMap   json;
        begin
          l_JO_Header := json();
          l_StringList1 := '';
          l_JA_PersonColList := json_list();
          l_JO_PersonColMap := json();
          l_StringList2 := '';
          l_JA_MonatSubColList := json_list();
          l_JO_MonatSubColMap := json();
          for l_cc in 1 .. l_ColList1.count()
            loop
              l_StringList1 := l_StringList1||l_ColList1(l_cc)||', ';
              l_JA_PersonColList.append(l_ColList1(l_cc));
              l_JO_PersonColMap.put(l_ColList1(l_cc),l_cc-1);
            end loop;
          for l_cc in 1 .. l_ColList2.count()
            loop
              l_StringList2 := l_StringList2||l_ColList2(l_cc)||', ';
              l_JA_MonatSubColList.append(l_ColList2(l_cc));
              l_JO_MonatSubColMap.put(l_ColList2(l_cc),l_cc-1);
            end loop;
          l_JO_Header.put('version','1.1 ColList:'||l_StringList1||' ['||l_StringList2||']');
          l_JO_Header.put('col_list',l_JA_PersonColList);
          l_JO_Header.put('col_map',l_JO_PersonColMap);
          l_JO_Header.put('col_list_4_mm',l_JA_MonatSubColList);
          l_JO_Header.put('col_map_4_mm',l_JO_MonatSubColMap);
          l_JA_MonatColList := json_list();
          for l_cc in 1 .. 12
            loop
              l_JA_MonatColList.append(l_cc);
            end loop;
          l_JO_Header.put('col_list_4_monat',l_JA_MonatColList);
          /* attach den gerade geschriebene json obj zum atribute header von obj JOReturnData
          */
          l_JO_ReturnData.put('header',l_JO_Header);
        end;
        /*
           Build data als JSON LIST
        */
        declare
          l_JA_PersonList json_list;
          l_JA_Person     json_list;
          l_JA_MonatList  json_list;
          l_JA_Monat      json_list;
        begin
          l_JA_PersonList := json_list();
          for l_GetPersRec in c_Personen
          loop
            -- process data record
            l_JA_Person := json_list();
            l_JA_Person.append(l_GetPersRec.PATTERN);
            l_JA_Person.append(l_GetPersRec.ORG_EINHEIT_NAME_KURZ);
            l_JA_Person.append(l_GetPersRec.ORG_EINHEIT_ID);
            l_JA_Person.append(l_GetPersRec.FAMILIENNAME);
            l_JA_Person.append(l_GetPersRec.VORNAME);
            l_JA_Person.append(l_GetPersRec.QKENNUNG);
            l_JA_Person.append(l_GetPersRec.PERSON_ID);
            l_JA_Person.append(l_GetPersRec.PERSON_GUELTIG_FLAG);
            l_JA_Person.append(l_GetPersRec.PERSON_TEST_FLAG);
            l_JA_Person.append(l_GetPersRec.DIENSTVERHAELTNIS_ID);
            l_JA_Person.append(l_GetPersRec.DV_GUELTIG_FLAG);
    --        l_JA_Person.append(l_GetPersRec.DV_ERSTELLT);
    --        l_JA_Person.append(l_GetPersRec.DV_DEAKTIVIERT);
            for l_MonatListRec in c_GetMonaten(l_GetPersRec.DIENSTVERHAELTNIS_ID,p_Jahr,l_RolleId) loop
              l_JA_Monat := json_list();
              l_JA_Monat.append(l_MonatListRec.MONATS_AUFZEICHNUNG_ID);
              l_JA_Monat.append(l_MonatListRec.MONAT_MM);
              l_JA_Monat.append(l_MonatListRec.MONAT_YYYY);
              l_JA_Monat.append(l_MonatListRec.STATUS_MONAT_ID);
              l_JA_Monat.append(l_MonatListRec.STATUS_MONAT_KB);
    --          l_JA_Monat.append(l_MonatListRec.STATUS_MONAT_NAME_KURZ);
              l_JA_Monat.append(l_MonatListRec.STATUS_MONAT_NAME_LANG);
              l_JA_Monat.append(l_MonatListRec.IS_MONAT_4_RO_LOCKED);
              l_JA_Person.append(l_JA_Monat);
            end loop;
            --l_JA_Person.append(l_JA_MonatList);
            l_JA_PersonList.append(l_JA_Person);
          end loop;
          /*
            attach di gesamct gerade gelesen datei zu atribute data von obj JOReturnData
          */
           l_JO_ReturnData.put('data',l_JA_PersonList);
         end;
         /*
            print die ganze structure durch htp
         */
         l_JO_ReturnData.htp(spaces=>true);
    end produce_json_with_error ;
    /
    set define on
    /*
       Synonyms/Grants for PROCEDURE PRODUCE_JSON_WITH_ERROR
    */
    /* SYNONYMS: keine */
    GRANT EXECUTE ON "PRODUCE_JSON_WITH_ERROR" TO "PUBLIC";
    
     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    call PRODUCE_JSON_WITH_ERROR()
    

    produce a output with circa 17347 byte, by byte 16266 produce a word  "Aufzeiclnung Arzt" instead of "Aufzeichnung Arzt"

    My Expierience: error depend of input data, sometime miss a charachter.

     
  • MIchele Paoli
    MIchele Paoli
    2011-09-08

    I have forgotten details of my environment
    - linux
    - oracle: 10.2.0.5.0

     
  • Thank you for the detailed report. When I have the time, I will try to reproduce and find the bug.
    I have a virtual machine with the same charset running 11.2.0, which I hope is able to produce the bug.

    /Jonas

     
  • Hi zizzim,

    Good news - I was able to reproduce the error.

    I seems that the function dbms_lob.substr sucks. Changing the amount from 8096 to 4096 made it work, but I don't really want to use that substr call anymore.

    Tom Kyte shows here http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:232814159006 how to upload a blob with a 4096 length buffer using dbms_lob.read. That's how I want to do it, so here is a fix which can be copied into the json_printer package:

    procedure htp_output_clob(my_clob clob, jsonp varchar2 default null) as 
        /*amount number := 4096;
        pos number := 1;
        len number;
        */
        l_amt    number default 30;
        l_off   number default 1;
        l_str   varchar2(4096);
        
      begin
        if(jsonp is not null) then htp.prn(jsonp||'('); end if;
        
        begin
          loop
            dbms_lob.read( my_clob, l_amt, l_off, l_str );
            -- it is vital to use htp.PRN to avoid 
            -- spurious line feeds getting added to your
            -- document
            htp.prn( l_str  );
            l_off := l_off+l_amt;
            l_amt := 4096;
          end loop;
        exception
          when no_data_found then NULL;
        end;
            
        /*
        len := dbms_lob.getlength(my_clob);
        
        while(pos < len) loop
          htp.prn(dbms_lob.substr(my_clob, amount, pos)); -- should I replace substr with dbms_lob.read?
          --dbms_output.put_line(dbms_lob.substr(my_clob, amount, pos)); 
          pos := pos + amount;
        end loop;
        */
        if(jsonp is not null) then htp.prn(')'); end if;
      end;
    

    Will you please test it and confirm whether or not it works?

    /Jonas

     
  • MIchele Paoli
    MIchele Paoli
    2011-09-12

    Will you please test it and confirm whether or not it works?

    no more error!

    I'm very happy!

    many thanks for your prompt Solution