This discussion is archived
10 Replies Latest reply: Jul 29, 2012 11:06 PM by kgronau RSS

Encoding issue - query MS SQL data from ORACLE

Tomeo Newbie
Currently Being Moderated
Hi folks,

I have db link from Oracle to MS SQL database. When I run below query, an issue with encoding occurs.
SQL> desc helios_tabcisorg
Name                 Type          Nullable Default Comments 
-------------------- ------------- -------- ------- -------- 
ZDROJ                VARCHAR2(15)                            
ID                   NUMBER                                  
CISLOORG             NUMBER                                  
NAZEV                VARCHAR2(200) Y                         
DRUHYNAZEV           VARCHAR2(200) Y                         
MISTO                VARCHAR2(200) Y                         
IDZEME               VARCHAR2(5)   Y                         
ULICE                VARCHAR2(200) Y                         
POPCISLO             VARCHAR2(30)  Y                         
PSC                  VARCHAR2(30)  Y                         
KONTAKT              VARCHAR2(40)  Y                         
DIC                  VARCHAR2(30)  Y                         
LHUTASPLATNOSTI      NUMBER        Y                         
STAV                 NUMBER                                  
PRAVNIFORMA          NUMBER        Y                         
DRUHCINNOSTI         NUMBER        Y                         
ICO                  VARCHAR2(30)  Y                         
JEODBERATEL          NUMBER        Y                         
JEDODAVATEL          NUMBER        Y                         
UPOZORNENI           VARCHAR2(500) Y                         
MENA                 VARCHAR2(3)   Y                         
DATPORIZENI          DATE          Y                         
AUTOR                VARCHAR2(128) Y                         
DATZMENY             DATE          Y                         
ZMENIL               VARCHAR2(128) Y                         
UDAJOZAPISUDOOBCHREJ VARCHAR2(500) Y                         
KREDIT               NUMBER(19,6)  Y                         
SALDO                NUMBER(19,6)  Y                         
DATUMSYNCHRONIZACE   DATE          Y    
  MERGE INTO HELIOS_TabCisOrg a
    USING (
            select 
                  'FO' ZDROJ, 
                  "ID" id,
                  "CisloOrg" cisloorg,
                  "Nazev" nazev,
                  "DruhyNazev" druhynazev,
                  "Misto" misto,
                  "IdZeme" idzeme,
                  "Ulice" ulice,
                  "PopCislo" popcislo,
                  "PSC" psc,
                  "Kontakt" kontakt,
                  "DIC" dic,
                  "LhutaSplatnosti" lhutasplatnosti,
                  "Stav" stav,
                  "PravniForma" pravniforma,
                  "DruhCinnosti" druhcinnosti,
                  "ICO" ico,
                  --h."Poznamka",
                  "JeOdberatel" jeodberatel,
                  "JeDodavatel" jedodavatel,
                  "Upozorneni" upozorneni,
                  "Mena" mena,
                  "DatPorizeni" datporizeni,
                  "Autor" autor,
                  "DatZmeny" datzmeny,
                  "Zmenil" zmenil,
                  "UdajOZapisuDoObchRej" udajozapisudoobchrej,
                  "Kredit" kredit,
                  "Saldo" saldo
                from "TabCisOrg"@HELIOSFO
           ) b
       ON (     a.zdroj = b.Zdroj
           and  a.ID = b.ID )
    WHEN MATCHED THEN
        UPDATE SET a.cisloorg = b.cisloorg,
                   a.nazev = b.nazev,
                   a.druhynazev = b.druhynazev,
                   a.misto = b.misto,
                   a.idzeme = b.idzeme,
                   a.ulice = b.ulice,
                   a.popcislo = b.popcislo,
                   a.psc = b.psc,
                   a.kontakt = b.kontakt,
                   a.dic = b.dic,
                   a.lhutasplatnosti = b.lhutasplatnosti,
                   a.stav = b.stav,
                   a.pravniforma = b.pravniforma,
                   a.druhcinnosti = b.druhcinnosti,
                   a.ico = b.ico,
                   a.jeodberatel = b.jeodberatel,
                   a.jedodavatel = b.jedodavatel,
                   a.upozorneni = b.upozorneni,
                   a.mena = b.mena,
                   a.datporizeni = b.datporizeni,
                   a.autor = b.autor,
                   a.datzmeny = b.datzmeny,
                   a.zmenil = b.zmenil,
                   a.udajozapisudoobchrej = b.udajozapisudoobchrej,
                   a.kredit = b.kredit,
                   a.saldo = b.saldo,
                   a.DatumSynchronizace = sysdate
       WHEN NOT MATCHED THEN
         insert 
           (zdroj, id, cisloorg, nazev, druhynazev, misto, idzeme, ulice,  popcislo,
            psc, kontakt, dic, lhutasplatnosti, stav, pravniforma, druhcinnosti, ico, jeodberatel, jedodavatel, 
            upozorneni, mena, datporizeni, autor, datzmeny, zmenil, udajozapisudoobchrej, kredit, saldo, DatumSynchronizace)
         values
           (b.zdroj, b.id, b.cisloorg, b.nazev, b.druhynazev, b.misto, b.idzeme, b.ulice, b.popcislo,
            b.psc, b.kontakt, b.dic, b.lhutasplatnosti, b.stav, b.pravniforma, b.druhcinnosti, b.ico, b.jeodberatel, b.jedodavatel,
            b.upozorneni, b.mena, b.datporizeni, b.autor, b.datzmeny, b.zmenil, b.udajozapisudoobchrej, b.kredit, b.saldo, sysdate);
SQL> set lines 500
SQL> select nazev  from helios_tabcisorg where rownum <10;

NAZEV
---------------------------------------------------------------
 K A M T R A N S     s .   r .   o .
 B O R A P E   s .   r . o .
 K A R E K A ,   s p o l .   s   r . o .
 B O R S   B˘Y e c l a v   a . s .
 B R A M I D   s . r . o .
 M i c h ß l e k   l o g i s t i c   s . r . o .
 C . S .   C A R G O   S l o v a k i a   a . s .
 M I R O S L A V   K U˘+ A
 L a d i s l a v   K r e n

9 rows selected.
Is there any parameter which could set an encoding during data query from other database?
  • 1. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
    initHELIOSSRO.ora
    # This is a sample agent init file that contains the HS parameters that are
    # needed for the Database Gateway for ODBC
    
    #
    # HS init parameters
    #
    HS_FDS_CONNECT_INFO = HELIOSSRO
    HS_LANGUAGE="CZECH_CZECH REPUBLIC.EE8MSWIN1250"
    HS_FDS_TRACE_LEVEL = DEBUG
    
    #
    # Environment variables required for the non-Oracle system
    #
    #set <envvar>=<value>
    initHELIOSFO.ora
    # This is a sample agent init file that contains the HS parameters that are
    # needed for the Database Gateway for ODBC
    
    #
    # HS init parameters
    #
    HS_FDS_CONNECT_INFO = HELIOSFO
    HS_LANGUAGE="CZECH_CZECH REPUBLIC.EE8MSWIN1250"
    HS_FDS_TRACE_LEVEL = DEBUG
    
    #
    # Environment variables required for the non-Oracle system
    #
    #set <envvar>=<value>
    Table TabCisOrg structure in MS SQL Database
    CREATE TABLE [dbo].[TabCisOrg](
         [ID] [int] IDENTITY(1,1) NOT NULL,
         [CisloOrg] [int] NOT NULL,
         [NadrizenaOrg] [int] NULL,
         [Nazev] [nvarchar](100) NOT NULL,
         [DruhyNazev] [nvarchar](100) NOT NULL,
         [Misto] [nvarchar](100) NOT NULL,
         [IdZeme] [nvarchar](3) NULL,
         [Region] [nvarchar](15) NULL,
         [Ulice] [nvarchar](100) NOT NULL,
         [OrCislo] [nvarchar](15) NOT NULL,
         [PopCislo] [nvarchar](15) NOT NULL,
         [PSC] [nvarchar](10) NULL,
         [PoBox] [nvarchar](40) NULL,
         [Kontakt] [nvarchar](40) NULL,
         [DIC] [nvarchar](15) NULL,
         [LhutaSplatnosti] [smallint] NULL,
         [Stav] [tinyint] NOT NULL,
         [PravniForma] [tinyint] NOT NULL,
         [DruhCinnosti] [int] NULL,
         [ICO] [nvarchar](20) NULL,
         [Sleva] [numeric](5, 2) NOT NULL,
         [OdHodnoty] [numeric](19, 6) NOT NULL,
         [CenovaUroven] [int] NULL,
         [IDSOZsleva] [int] NULL,
         [IDSOZnazev] [int] NULL,
         [Poznamka] [ntext] NULL,
         [FormaUhrady] [nvarchar](30) NULL,
         [JeOdberatel] [bit] NOT NULL,
         [JeDodavatel] [bit] NOT NULL,
         [VernostniProgram] [bit] NOT NULL,
         [OdpOs] [int] NULL,
         [Upozorneni] [nvarchar](255) NULL,
         [CisloOrgDos] [nvarchar](20) NOT NULL,
         [Mena] [nvarchar](3) NULL,
         [DatPorizeni] [datetime] NOT NULL,
         [Autor] [nvarchar](128) NOT NULL,
         [DatZmeny] [datetime] NULL,
         [Zmenil] [nvarchar](128) NULL,
         [BlokovaniEditoru] [smallint] NULL,
         [Fakturacni] [bit] NOT NULL,
         [MU] [bit] NOT NULL,
         [Prijemce] [bit] NOT NULL,
         [UdajOZapisuDoObchRej] [nvarchar](128) NOT NULL,
         [IDBankSpojeni] [int] NULL,
         [IDBankSpojPlatak] [int] NULL,
         [CarovyKodEAN] [nvarchar](13) NULL,
         [PostAddress] [nvarchar](255) NOT NULL,
         [Kredit] [numeric](19, 6) NOT NULL,
         [Saldo] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl1] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl2] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl3] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl4] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl5] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl6] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl0] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl1] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl2] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl3] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl4] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl5] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl6] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl0] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl1] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl2] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl3] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl4] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl5] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl6] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl0] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl1] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl2] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl3] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl4] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl5] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl6] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl0] [numeric](19, 6) NOT NULL,
         [FaSumaCelkem] [numeric](19, 6) NULL,
         [PozastavenoCelkem] [numeric](19, 6) NULL,
         [FaAktualizovano] [datetime] NULL,
         [PlneniBezDPH] [bit] NOT NULL,
         [Jazyk] [nvarchar](15) NULL,
         [DatumNeupominani] [datetime] NULL,
         [CenovaUrovenNakup] [int] NULL,
         [TIN] [nvarchar](17) NOT NULL,
         [EvCisDanovySklad] [nvarchar](30) NULL,
         [DICsk] [nvarchar](15) NULL,
         [SlevaSozNa] [tinyint] NULL,
         [SlevaSkupZbo] [tinyint] NULL,
         [SlevaKmenZbo] [tinyint] NULL,
         [SlevaStavSkladu] [tinyint] NULL,
         [SlevaZbozi] [tinyint] NULL,
         [SlevaOrg] [tinyint] NULL,
         [IdTxtPenFak] [int] NULL,
         [Logo] [image] NULL,
         [KorekceSplatnoAuto] [int] NULL,
         [KorekceSplatnoUziv] [int] NULL,
         [NapocetProPT] [tinyint] NOT NULL,
         [DatPorizeni_D]  AS (datepart(day,[DatPorizeni])),
         [DatPorizeni_M]  AS (datepart(month,[DatPorizeni])),
         [DatPorizeni_Y]  AS (datepart(year,[DatPorizeni])),
         [DatPorizeni_Q]  AS (datepart(quarter,[DatPorizeni])),
         [DatPorizeni_W]  AS (datepart(week,[DatPorizeni])),
         [DatPorizeni_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatPorizeni],0),0),0)),
         [DatZmeny_D]  AS (datepart(day,[DatZmeny])),
         [DatZmeny_M]  AS (datepart(month,[DatZmeny])),
         [DatZmeny_Y]  AS (datepart(year,[DatZmeny])),
         [DatZmeny_Q]  AS (datepart(quarter,[DatZmeny])),
         [DatZmeny_W]  AS (datepart(week,[DatZmeny])),
         [DatZmeny_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatZmeny],0),0),0)),
         [KreditZustatek]  AS (CONVERT([numeric](19,6),[Kredit]-[Saldo],0)),
         [FaAktualizovano_D]  AS (datepart(day,[FaAktualizovano])),
         [FaAktualizovano_M]  AS (datepart(month,[FaAktualizovano])),
         [FaAktualizovano_Y]  AS (datepart(year,[FaAktualizovano])),
         [FaAktualizovano_Q]  AS (datepart(quarter,[FaAktualizovano])),
         [FaAktualizovano_W]  AS (datepart(week,[FaAktualizovano])),
         [FaAktualizovano_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[FaAktualizovano],0),0),0)),
         [DatumNeupominani_D]  AS (datepart(day,[DatumNeupominani])),
         [DatumNeupominani_M]  AS (datepart(month,[DatumNeupominani])),
         [DatumNeupominani_Y]  AS (datepart(year,[DatumNeupominani])),
         [DatumNeupominani_Q]  AS (datepart(quarter,[DatumNeupominani])),
         [DatumNeupominani_W]  AS (datepart(week,[DatumNeupominani])),
         [DatumNeupominani_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatumNeupominani],0),0),0)),
         [Logo_DatLen]  AS (isnull(datalength([Logo]),(0))),
         [EORI] [nvarchar](17) NOT NULL,
         [Logo_BGJ]  AS (case when [Logo] IS NULL then NULL else case when substring([Logo],(1),(2))=0x424D then N'Bitmap' else case when substring([Logo],(1),(3))=0x474946 then N'GIF' else case when substring([Logo],(1),(2))=0xFFD8 then N'JPEG' else case when substring([Logo],(1),(4))=0x00000100 then N'Icon' else case when substring([Logo],(1),(8))=0x89504E470D0A1A0A then N'PNG' else case when substring([Logo],(1),(4))=0x54494646 then N'TIFF' else '' end end end end end end end),
         [UliceSCisly]  AS (([Ulice]+N' ')+case when [PopCislo]<>'' AND [OrCislo]<>'' then ([PopCislo]+N'/')+[OrCislo] else [PopCislo]+[OrCislo] end),
         [Firma]  AS (ltrim(substring(replace([Nazev],nchar((13))+nchar((10)),nchar((32))),(1),(100)))),
         [DruhDopravy] [tinyint] NULL,
         [DodaciPodminky] [nvarchar](3) NOT NULL,
         [PostovniAdresa]  AS (CONVERT([nvarchar](255),case when [PostAddress]='' then (((((([Nazev]+nchar((13)))+nchar((10)))+(([Ulice]+nchar((32)))+case when [PopCislo]<>'' AND [OrCislo]<>'' then ([PopCislo]+N'/')+[OrCislo] else [PopCislo]+[OrCislo] end))+nchar((13)))+nchar((10)))+ltrim(isnull([PSC],'')+nchar((32))))+[Misto] else [PostAddress] end,0)),
         [KorekceSplatnoUzivD] [int] NULL,
         [RezimPenalizace] [tinyint] NOT NULL,
         [Penale] [tinyint] NOT NULL,
         [Partner] [nvarchar](3) NULL,
         [PlatceDPH] [bit] NOT NULL,
         [IDSOZExpirace] [int] NULL
    simple query run from SQL*PLUS:
    Connected to:
    Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    
    SQL> select "ID", "Nazev" from "TabCisOrg"@HELIOSSRO where "ID" = 14;
    
            ID Nazev
    ---------- -------------------------------------------------------------------
            14 Josef CÝsa°, s. r. o.
  • 2. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
    Trace log from /HS/trace
    Oracle Corporation --- FRIDAY    JUL 20 2012 19:48:30.319
    
    
    Heterogeneous Agent Release 
    11.2.0.1.0 
    
    
    
    
    Oracle Corporation --- FRIDAY    JUL 20 2012 19:48:30.318
    
        Version 11.2.0.1.0
    
    Entered hgogprd
    HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
    Entered hgosdip
     setting HS_OPEN_CURSORS to default of 50
     setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
     setting HS_FDS_RECOVERY_PWD to default value
     setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
     setting HS_IDLE_TIMEOUT to default of 0
     setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
     setting HS_NLS_NCHAR to default of "UCS2"
     setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
     setting HS_FDS_DATE_MAPPING to default of "DATE"
     setting HS_RPC_FETCH_REBLOCKING to default of "ON"
     setting HS_FDS_FETCH_ROWS to default of "100"
     setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
     setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
     setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
     setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
     setting HS_FDS_MAP_NCHAR to default of "TRUE"
     setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
     setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
     setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
     setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
     setting HS_FDS_QUERY_DRIVER to default of "TRUE"
     setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
     Parameter HS_FDS_QUOTE_IDENTIFIER is not set
     setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
     setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
     setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
    Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
     setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
     setting HS_FDS_DELAYED_OPEN to default of "TRUE"
     setting HS_FDS_WORKAROUNDS to default of "0"
    Exiting hgosdip, rc=0
     ORACLE_SID is "HELIOSSRO"
     Product-Info:
      Port Rls/Upd:1/0 PrdStat:0
      Agent:Oracle Database Gateway for ODBC
      Facility:hsa
      Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:HELIOSSRO
    Exiting hgogprd, rc=0
    Entered hgoinit
    HOCXU_COMP_CSET=1
    HOCXU_DRV_CSET=170
    HOCXU_DRV_NCHAR=1000
    HOCXU_DB_CSET=170
    HOCXU_SEM_VER=112000
    Entered hgolofn at 2012/07/20-19:48:30
    Exiting hgolofn, rc=0 at 2012/07/20-19:48:30
    HOSGIP for "HS_OPEN_CURSORS" returned "50"
    HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
    HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
    HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
    HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
    HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
    HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
    HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
    HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
    Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
    treat_SQLLEN_as_compiled = 1
    Exiting hgoinit, rc=0 at 2012/07/20-19:48:30
    Entered hgolgon at 2012/07/20-19:48:30
     reco:0, name:sa, tflag:0
    Entered hgosuec at 2012/07/20-19:48:30
    Exiting hgosuec, rc=0 at 2012/07/20-19:48:30
    HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
    HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
    HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
    HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
    HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
    HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
    HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
    HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
    HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
    HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
     using sa as default value for "HS_FDS_DEFAULT_OWNER"
    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
    Entered hgocont at 2012/07/20-19:48:30
     HS_FDS_CONNECT_INFO = "HELIOSSRO"
     RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
    Entered hgogenconstr at 2012/07/20-19:48:30
     dsn:HELIOSSRO, name:sa
     optn:
    Entered hgocip at 2012/07/20-19:48:30
     dsn:HELIOSSRO
    Exiting hgocip, rc=0 at 2012/07/20-19:48:30
    Exiting hgogenconstr, rc=0 at 2012/07/20-19:48:30
    Entered hgopoer at 2012/07/20-19:48:30
    hgopoer, line 233: got native error 5701 and sqlstate 01000; message follows...
    [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Helios_SRO'. {01000,NativeErr = 5701}[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. {01000,NativeErr = 5703}
    Exiting hgopoer, rc=0 at 2012/07/20-19:48:30
    hgocont, line 2686: calling SqlDriverConnect got sqlstate 01000
    Entered hgolosf at 2012/07/20-19:48:30
    Exiting hgolosf, rc=0 at 2012/07/20-19:48:30
    DriverName:SQLSRV32.DLL, DriverVer:06.01.7601
    DBMS Name:Microsoft SQL Server, DBMS Version:10.50.2500
    Exiting hgocont, rc=0 at 2012/07/20-19:48:30 with error ptr FILE:hgocont.c LINE:2686 ID:SQLDriverConnect
    SQLGetInfo returns Y for SQL_CATALOG_NAME
    SQLGetInfo returns 128 for SQL_MAX_CATALOG_NAME_LEN
    Exiting hgolgon, rc=0 at 2012/07/20-19:48:30
    Entered hgoulcp at 2012/07/20-19:48:30
    Entered hgowlst at 2012/07/20-19:48:30
    Exiting hgowlst, rc=0 at 2012/07/20-19:48:30
    SQLGetInfo returns 0x1f for SQL_OWNER_USAGE
    TXN Capable:2, Isolation Option:0xf
    SQLGetInfo returns 128 for SQL_MAX_SCHEMA_NAME_LEN
    SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
    SQLGetInfo returns 134 for SQL_MAX_PROCEDURE_NAME_LEN
    SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
    SQLGetInfo returns Y for SQL_COLUMN_ALIAS
     3 instance capabilities will be uploaded
      capno:1989, context:0x00000000, add-info:        0 
      capno:1991, context:0x0001ffff, add-info:        0 
      capno:1992, context:0x0001ffff, add-info:        0 
    Exiting hgoulcp, rc=0 at 2012/07/20-19:48:30
    Entered hgouldt at 2012/07/20-19:48:30
     NO instance DD translations were uploaded
    Exiting hgouldt, rc=0 at 2012/07/20-19:48:30
    Entered hgobegn at 2012/07/20-19:48:30
     tflag:0 , initial:1
     hoi:0x12ee28, ttid (len 23) is ...
      00: 4445562E 38313039 35663565 2E332E31  [DEV.81095f5e.3.1]
      10: 372E3133 343536                      [7.13456]
                     tbid (len 20) is ...
      00: 4445565B 332E3137 2E313334 35365D5B  [DEV[3.17.13456][]
      10: 312E345D                             [1.4]]
    Exiting hgobegn, rc=0 at 2012/07/20-19:48:30
    Entered hgodtab at 2012/07/20-19:48:30
     count:1
      table: TabCisOrg
     Allocate hoada[0] @ 0000000005191200
     Free hoada[0] @ 0000000005191200
    Entered hgopdsc at 2012/07/20-19:48:30
    Describing procedure sa.TabCisOrg
    Output hoada
    hgopdsc, line 1426: NO hoada to print
    Exiting hgopdsc, rc=942 at 2012/07/20-19:48:30
    The hoada for table TabCisOrg follows...
    hgodtab, line 904: NO hoada to print
    Exiting hgodtab, rc=0 at 2012/07/20-19:48:30
    Entered hgopars, cursor id 1 at 2012/07/20-19:48:30
     type:0
    SQL text from hgopars, id=1, len=25 ...
         00: 53454C45 4354202A 2046524F 4D202254  [SELECT * FROM "T]
         10: 61624369 734F7267 22                 [abCisOrg"]
    Exiting hgopars, rc=0 at 2012/07/20-19:48:30
    Entered hgoopen, cursor id 1 at 2012/07/20-19:48:30
    hgoopen, line 87: NO hoada to print
     Deferred open until first fetch.
    Exiting hgoopen, rc=0 at 2012/07/20-19:48:30
    Entered hgodscr, cursor id 1 at 2012/07/20-19:48:30
     Allocate hoada @ 0000000005191200
    Entered hgopcda at 2012/07/20-19:48:30
     Column:1(ID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:2(CisloOrg): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:3(NadrizenaOrg): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:0, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:4(Nazev): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:0, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:5(DruhyNazev): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:0, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:6(Misto): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:0, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:7(IdZeme): dtype:-9 (WVARCHAR), prc/scl:3/0, nullbl:1, octet:6, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:8(Region): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:9(Ulice): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:0, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:10(OrCislo): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:0, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:11(PopCislo): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:0, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:12(PSC): dtype:-9 (WVARCHAR), prc/scl:10/0, nullbl:1, octet:20, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:13(PoBox): dtype:-9 (WVARCHAR), prc/scl:40/0, nullbl:1, octet:80, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:14(Kontakt): dtype:-9 (WVARCHAR), prc/scl:40/0, nullbl:1, octet:80, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:15(DIC): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:16(LhutaSplatnosti): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:17(Stav): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:0, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:18(PravniForma): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:0, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:19(DruhCinnosti): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:20(ICO): dtype:-9 (WVARCHAR), prc/scl:20/0, nullbl:1, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:21(Sleva): dtype:2 (NUMERIC), prc/scl:5/2, nullbl:0, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:22(OdHodnoty): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:23(CenovaUroven): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:24(IDSOZsleva): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:25(IDSOZnazev): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:26(Poznamka): dtype:-10 (WLONGVARCHAR), prc/scl:1073741823/0, nullbl:1, octet:2147483646, sign:1, radix:0
    Column 26 (Poznamka): dtype -10 (WLONGVARCHAR): this datatype is not supported.
    Entered hgopcda at 2012/07/20-19:48:30
     Column:26(FormaUhrady): dtype:-9 (WVARCHAR), prc/scl:30/0, nullbl:1, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:27(JeOdberatel): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:28(JeDodavatel): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:29(VernostniProgram): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:30(OdpOs): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:31(Upozorneni): dtype:-9 (WVARCHAR), prc/scl:255/0, nullbl:1, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:32(CisloOrgDos): dtype:-9 (WVARCHAR), prc/scl:20/0, nullbl:0, octet:40, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:33(Mena): dtype:-9 (WVARCHAR), prc/scl:3/0, nullbl:1, octet:6, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:34(DatPorizeni): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:0, octet:6, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:35(Autor): dtype:-9 (WVARCHAR), prc/scl:128/0, nullbl:0, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:36(DatZmeny): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:37(Zmenil): dtype:-9 (WVARCHAR), prc/scl:128/0, nullbl:1, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:38(BlokovaniEditoru): dtype:5 (SMALLINT), prc/scl:5/0, nullbl:1, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:39(Fakturacni): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:40(MU): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:41(Prijemce): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:42(UdajOZapisuDoObchRej): dtype:-9 (WVARCHAR), prc/scl:128/0, nullbl:0, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:43(IDBankSpojeni): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:44(IDBankSpojPlatak): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:256, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:45(CarovyKodEAN): dtype:-9 (WVARCHAR), prc/scl:13/0, nullbl:1, octet:26, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:46(PostAddress): dtype:-9 (WVARCHAR), prc/scl:255/0, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:47(Kredit): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:48(Saldo): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:49(UhrazenoPredSpl1): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
  • 3. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
     Column:50(UhrazenoPredSpl2): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:51(UhrazenoPredSpl3): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:52(UhrazenoPredSpl4): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:53(UhrazenoPredSpl5): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:54(UhrazenoPredSpl6): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:55(UhrazenoPredSpl0): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:56(UhrazenoPoSpl1): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:57(UhrazenoPoSpl2): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:58(UhrazenoPoSpl3): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:59(UhrazenoPoSpl4): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:60(UhrazenoPoSpl5): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:61(UhrazenoPoSpl6): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:62(UhrazenoPoSpl0): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:63(NeuhrazenoPredSpl1): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:64(NeuhrazenoPredSpl2): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:65(NeuhrazenoPredSpl3): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:66(NeuhrazenoPredSpl4): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:67(NeuhrazenoPredSpl5): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:68(NeuhrazenoPredSpl6): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:69(NeuhrazenoPredSpl0): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:70(NeuhrazenoPoSpl1): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:71(NeuhrazenoPoSpl2): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:72(NeuhrazenoPoSpl3): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:73(NeuhrazenoPoSpl4): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:74(NeuhrazenoPoSpl5): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:75(NeuhrazenoPoSpl6): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:76(NeuhrazenoPoSpl0): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:77(FaSumaCelkem): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:1, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:78(PozastavenoCelkem): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:1, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:79(FaAktualizovano): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:80(PlneniBezDPH): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:81(Jazyk): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:82(DatumNeupominani): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:83(CenovaUrovenNakup): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:84(TIN): dtype:-9 (WVARCHAR), prc/scl:17/0, nullbl:0, octet:34, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:85(EvCisDanovySklad): dtype:-9 (WVARCHAR), prc/scl:30/0, nullbl:1, octet:60, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:86(DICsk): dtype:-9 (WVARCHAR), prc/scl:15/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:87(SlevaSozNa): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:88(SlevaSkupZbo): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:89(SlevaKmenZbo): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:90(SlevaStavSkladu): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:91(SlevaZbozi): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:92(SlevaOrg): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:93(IdTxtPenFak): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:94(Logo): dtype:-4 (LONGVARBINARY), prc/scl:2147483647/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:95(KorekceSplatnoAuto): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:96(KorekceSplatnoUziv): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:97(NapocetProPT): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:0, octet:30, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:98(DatPorizeni_D): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:99(DatPorizeni_M): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:100(DatPorizeni_Y): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:101(DatPorizeni_Q): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:102(DatPorizeni_W): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:103(DatPorizeni_X): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:104(DatZmeny_D): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:105(DatZmeny_M): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:106(DatZmeny_Y): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:107(DatZmeny_Q): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:108(DatZmeny_W): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:109(DatZmeny_X): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:110(KreditZustatek): dtype:2 (NUMERIC), prc/scl:19/6, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:111(FaAktualizovano_D): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:112(FaAktualizovano_M): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:113(FaAktualizovano_Y): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:114(FaAktualizovano_Q): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:115(FaAktualizovano_W): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:116(FaAktualizovano_X): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:117(DatumNeupominani_D): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:118(DatumNeupominani_M): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:119(DatumNeupominani_Y): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:120(DatumNeupominani_Q): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:121(DatumNeupominani_W): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:122(DatumNeupominani_X): dtype:93 (TIMESTAMP), prc/scl:23/3, nullbl:1, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:123(Logo_DatLen): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:30, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:124(EORI): dtype:-9 (WVARCHAR), prc/scl:17/0, nullbl:0, octet:34, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:125(Logo_BGJ): dtype:-9 (WVARCHAR), prc/scl:6/0, nullbl:1, octet:12, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:126(UliceSCisly): dtype:-9 (WVARCHAR), prc/scl:132/0, nullbl:0, octet:264, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:127(Firma): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:1, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:128(DruhDopravy): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:1, octet:200, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:129(DodaciPodminky): dtype:-9 (WVARCHAR), prc/scl:3/0, nullbl:0, octet:6, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:130(PostovniAdresa): dtype:-9 (WVARCHAR), prc/scl:255/0, nullbl:1, octet:510, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:131(KorekceSplatnoUzivD): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:510, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:132(RezimPenalizace): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:0, octet:510, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:133(Penale): dtype:-6 (TINYINT), prc/scl:3/0, nullbl:0, octet:510, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:134(Partner): dtype:-9 (WVARCHAR), prc/scl:3/0, nullbl:1, octet:6, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:135(PlatceDPH): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:6, sign:0, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:136(IDSOZExpirace): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:6, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    hgodscr, line 910: Printing hoada @ 0000000005191200
     MAX:136, ACTUAL:136, BRC:100, WHT=5 (SELECT_LIST)
     hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR,0x20:NEGATIVE_HOADADTY)
    DTY               NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
      4 INTEGER       N          4          4   0/  0    0   0   0 ID
      4 INTEGER       N          4          4   0/  0    0   0   0 CisloOrg
      4 INTEGER       Y          4          4   0/  0    0   0   0 NadrizenaOrg
     12 VARCHAR       N        200        200 128/100 1000   0  40 Nazev
     12 VARCHAR       N        200        200 128/100 1000   0  40 DruhyNazev
     12 VARCHAR       N        200        200 128/100 1000   0  40 Misto
     12 VARCHAR       Y          6          6 128/  3 1000   0  40 IdZeme
     12 VARCHAR       Y         30         30 128/ 15 1000   0  40 Region
     12 VARCHAR       N        200        200 128/100 1000   0  40 Ulice
     12 VARCHAR       N         30         30 128/ 15 1000   0  40 OrCislo
     12 VARCHAR       N         30         30 128/ 15 1000   0  40 PopCislo
     12 VARCHAR       Y         20         20 128/ 10 1000   0  40 PSC
     12 VARCHAR       Y         80         80 128/ 40 1000   0  40 PoBox
     12 VARCHAR       Y         80         80 128/ 40 1000   0  40 Kontakt
     12 VARCHAR       Y         30         30 128/ 15 1000   0  40 DIC
      5 SMALLINT      Y          2          2   0/  0    0   0   0 LhutaSplatnosti
     -7 BIT           N          1          1   0/  0    0   0  20 Stav
     -7 BIT           N          1          1   0/  0    0   0  20 PravniForma
      4 INTEGER       Y          4          4   0/  0    0   0   0 DruhCinnosti
     12 VARCHAR       Y         40         40 128/ 20 1000   0  40 ICO
      3 DECIMAL       N          8          8   5/  2    0   0   0 Sleva
      3 DECIMAL       N         22         22  19/  6    0   0   0 OdHodnoty
      4 INTEGER       Y          4          4   0/  0    0   0   0 CenovaUroven
      4 INTEGER       Y          4          4   0/  0    0   0   0 IDSOZsleva
      4 INTEGER       Y          4          4   0/  0    0   0   0 IDSOZnazev
     12 VARCHAR       Y         60         60 128/ 30 1000   0  40 FormaUhrady
     -7 BIT           N          1          1   0/  0    0   0  20 JeOdberatel
     -7 BIT           N          1          1   0/  0    0   0  20 JeDodavatel
     -7 BIT           N          1          1   0/  0    0   0  20 VernostniProgram
      4 INTEGER       Y          4          4   0/  0    0   0   0 OdpOs
     12 VARCHAR       Y        510        510 128/255 1000   0  40 Upozorneni
     12 VARCHAR       N         40         40 128/ 20 1000   0  40 CisloOrgDos
     12 VARCHAR       Y          6          6 128/  3 1000   0  40 Mena
     91 DATE          N         16         16   0/  0    0   0   0 DatPorizeni
     12 VARCHAR       N        256        256 128/128 1000   0  40 Autor
     91 DATE          Y         16         16   0/  0    0   0   0 DatZmeny
     12 VARCHAR       Y        256        256 128/128 1000   0  40 Zmenil
      5 SMALLINT      Y          2          2   0/  0    0   0   0 BlokovaniEditoru
     -7 BIT           N          1          1   0/  0    0   0  20 Fakturacni
     -7 BIT           N          1          1   0/  0    0   0  20 MU
     -7 BIT           N          1          1   0/  0    0   0  20 Prijemce
     12 VARCHAR       N        256        256 128/128 1000   0  40 UdajOZapisuDoObchRej
      4 INTEGER       Y          4          4   0/  0    0   0   0 IDBankSpojeni
      4 INTEGER       Y          4          4   0/  0    0   0   0 IDBankSpojPlatak
     12 VARCHAR       Y         26         26 128/ 13 1000   0  40 CarovyKodEAN
     12 VARCHAR       N        510        510 128/255 1000   0  40 PostAddress
      3 DECIMAL       N         22         22  19/  6    0   0   0 Kredit
      3 DECIMAL       N         22         22  19/  6    0   0   0 Saldo
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl1
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl2
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl3
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl4
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl5
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl6
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPredSpl0
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl1
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl2
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl3
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl4
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl5
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl6
      3 DECIMAL       N         22         22  19/  6    0   0   0 UhrazenoPoSpl0
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl1
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl2
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl3
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl4
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl5
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl6
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPredSpl0
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl1
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl2
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl3
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl4
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl5
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl6
      3 DECIMAL       N         22         22  19/  6    0   0   0 NeuhrazenoPoSpl0
      3 DECIMAL       Y         22         22  19/  6    0   0   0 FaSumaCelkem
      3 DECIMAL       Y         22         22  19/  6    0   0   0 PozastavenoCelkem
     91 DATE          Y         16         16   0/  0    0   0   0 FaAktualizovano
     -7 BIT           N          1          1   0/  0    0   0  20 PlneniBezDPH
     12 VARCHAR       Y         30         30 128/ 15 1000   0  40 Jazyk
     91 DATE          Y         16         16   0/  0    0   0   0 DatumNeupominani
      4 INTEGER       Y          4          4   0/  0    0   0   0 CenovaUrovenNakup
     12 VARCHAR       N         34         34 128/ 17 1000   0  40 TIN
     12 VARCHAR       Y         60         60 128/ 30 1000   0  40 EvCisDanovySklad
     12 VARCHAR       Y         30         30 128/ 15 1000   0  40 DICsk
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaSozNa
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaSkupZbo
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaKmenZbo
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaStavSkladu
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaZbozi
     -7 BIT           Y          1          1   0/  0    0   0  20 SlevaOrg
      4 INTEGER       Y          4          4   0/  0    0   0   0 IdTxtPenFak
     -4 LONGVARBINARY Y          0          0   0/  0    0   0  20 Logo
      4 INTEGER       Y          4          4   0/  0    0   0   0 KorekceSplatnoAuto
      4 INTEGER       Y          4          4   0/  0    0   0   0 KorekceSplatnoUziv
     -7 BIT           N          1          1   0/  0    0   0  20 NapocetProPT
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatPorizeni_D
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatPorizeni_M
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatPorizeni_Y
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatPorizeni_Q
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatPorizeni_W
     91 DATE          Y         16         16   0/  0    0   0   0 DatPorizeni_X
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatZmeny_D
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatZmeny_M
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatZmeny_Y
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatZmeny_Q
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatZmeny_W
     91 DATE          Y         16         16   0/  0    0   0   0 DatZmeny_X
      3 DECIMAL       Y         22         22  19/  6    0   0   0 KreditZustatek
      4 INTEGER       Y          4          4   0/  0    0   0   0 FaAktualizovano_D
      4 INTEGER       Y          4          4   0/  0    0   0   0 FaAktualizovano_M
      4 INTEGER       Y          4          4   0/  0    0   0   0 FaAktualizovano_Y
      4 INTEGER       Y          4          4   0/  0    0   0   0 FaAktualizovano_Q
      4 INTEGER       Y          4          4   0/  0    0   0   0 FaAktualizovano_W
     91 DATE          Y         16         16   0/  0    0   0   0 FaAktualizovano_X
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatumNeupominani_D
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatumNeupominani_M
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatumNeupominani_Y
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatumNeupominani_Q
      4 INTEGER       Y          4          4   0/  0    0   0   0 DatumNeupominani_W
     91 DATE          Y         16         16   0/  0    0   0   0 DatumNeupominani_X
      4 INTEGER       N          4          4   0/  0    0   0   0 Logo_DatLen
     12 VARCHAR       N         34         34 128/ 17 1000   0  40 EORI
     12 VARCHAR       Y         12         12 128/  6 1000   0  40 Logo_BGJ
     12 VARCHAR       N        264        264 128/132 1000   0  40 UliceSCisly
     12 VARCHAR       Y        200        200 128/100 1000   0  40 Firma
     -7 BIT           Y          1          1   0/  0    0   0  20 DruhDopravy
     12 VARCHAR       N          6          6 128/  3 1000   0  40 DodaciPodminky
     12 VARCHAR       Y        510        510 128/255 1000   0  40 PostovniAdresa
      4 INTEGER       Y          4          4   0/  0    0   0   0 KorekceSplatnoUzivD
     -7 BIT           N          1          1   0/  0    0   0  20 RezimPenalizace
     -7 BIT           N          1          1   0/  0    0   0  20 Penale
     12 VARCHAR       Y          6          6 128/  3 1000   0  40 Partner
     -7 BIT           N          1          1   0/  0    0   0  20 PlatceDPH
      4 INTEGER       Y          4          4   0/  0    0   0   0 IDSOZExpirace
    Exiting hgodscr, rc=0 at 2012/07/20-19:48:30
    Entered hgoclse, cursor id 1 at 2012/07/20-19:48:30
    Exiting hgoclse, rc=0 at 2012/07/20-19:48:30
    Entered hgodafr, cursor id 1 at 2012/07/20-19:48:30
     Free hoada @ 0000000005191200
    Exiting hgodafr, rc=0 at 2012/07/20-19:48:30
    Entered hgopars, cursor id 1 at 2012/07/20-19:48:30
     type:0
    SQL text from hgopars, id=1, len=62 ...
         00: 53454C45 43542041 312E2249 44222C41  [SELECT A1."ID",A]
         10: 312E224E 617A6576 22204652 4F4D2022  [1."Nazev" FROM "]
         20: 54616243 69734F72 67222041 31205748  [TabCisOrg" A1 WH]
         30: 45524520 41312E22 4944223D 3134      [ERE A1."ID"=14]
    Exiting hgopars, rc=0 at 2012/07/20-19:48:30
    Entered hgoopen, cursor id 1 at 2012/07/20-19:48:30
    hgoopen, line 87: NO hoada to print
     Deferred open until first fetch.
    Exiting hgoopen, rc=0 at 2012/07/20-19:48:30
    Entered hgodscr, cursor id 1 at 2012/07/20-19:48:30
     Allocate hoada @ 00000000051911A8
    Entered hgopcda at 2012/07/20-19:48:30
     Column:1(ID): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    Entered hgopcda at 2012/07/20-19:48:30
     Column:2(Nazev): dtype:-9 (WVARCHAR), prc/scl:100/0, nullbl:0, octet:200, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2012/07/20-19:48:30
    hgodscr, line 910: Printing hoada @ 00000000051911A8
     MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
     hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
    DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
      4 INTEGER N          4          4   0/  0    0   0   0 ID
     12 VARCHAR N        200        200 128/100 1000   0  40 Nazev
    Exiting hgodscr, rc=0 at 2012/07/20-19:48:31
    Entered hgoftch, cursor id 1 at 2012/07/20-19:48:31
    hgoftch, line 130: Printing hoada @ 00000000051911A8
     MAX:2, ACTUAL:2, BRC:100, WHT=5 (SELECT_LIST)
     hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
    DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
      4 INTEGER N          4          4   0/  0    0   0   0 ID
     12 VARCHAR N        200        200 128/100 1000   0  40 Nazev
     Performing delayed open.
     SQLBindCol: column 1, cdatatype: -16, bflsz: 4
     SQLBindCol: column 2, cdatatype: -8, bflsz: 202
     SQLFetch: row: 1, column 1, bflsz: 4, bflar: 4
     SQLFetch: row: 1, column 1, bflsz: 4,  bflar: 4, (bfl: 4, mbl: 4)
     SQLFetch: row: 1, column 2, bflsz: 202, bflar: 42
     SQLFetch: row: 1, column 2, bflsz: 202,  bflar: 42, (bfl: 200, mbl: 200)
     1 rows fetched
    Exiting hgoftch, rc=0 at 2012/07/20-19:48:31
    Entered hgoftch, cursor id 1 at 2012/07/20-19:48:31
    hgoftch, line 130: Printing hoada @ 00000000051911A8
     MAX:2, ACTUAL:2, BRC:1, WHT=5 (SELECT_LIST)
     hoadaMOD bit-values found (0x40:TREAT_AS_NCHAR)
    DTY         NULL-OK  LEN  MAXBUFLEN   PR/SC  CST IND MOD NAME
      4 INTEGER N          4          4   0/  0    0   0   0 ID
     12 VARCHAR N         42        200 128/100 1000   0  40 Nazev
     0 rows fetched
    Exiting hgoftch, rc=1403 at 2012/07/20-19:48:31
     
  • 4. Re: Encoding issue - query MS SQL data from ORACLE
    kgronau Guru
    Currently Being Moderated
    Can you please confirm:
    When you run the select in SQL*Plus the output is correct, but when you use a PL/SQL code each character is padded with a space/null character?

    Edited by: kgronau on Jul 23, 2012 10:26 AM
  • 5. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
    Hi, yes, as you said. In SQL*PLUS it's correct, but in PL/SQL it returns incorrect characters, resp. output is incorrect.
  • 6. Re: Encoding issue - query MS SQL data from ORACLE
    kgronau Guru
    Currently Being Moderated
    That's sounds like a known defect in the product.

    Does the table at the SQL Server side belong to dbo or to a dedicated user?
    As a test, could you pleas add the username who owns the table to the foreign objects in your code? Does it then work?

    Edited by: kgronau on Jul 26, 2012 9:43 AM

    issue is tracked as defect # 13950747 - NCHAR/NVARCHAR USING DG4MSQL ADDS A SPACE/BLANK TO EVERY CHARACTER USING PL/SQL
  • 7. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
    Hi, thanks for reply.

    I don't fully understand what you mean by: "add the username who owns the table to the foreign objects in your code"
    Please send me some dummy examaple, just to buy sure.

    This table is created in MS SQL as: dbo.TabCisOrg

    Is there any workaround for this defect?
    CREATE TABLE [dbo].[TabCisOrg](
         [ID] [int] IDENTITY(1,1) NOT NULL,
         [CisloOrg] [int] NOT NULL,
         [NadrizenaOrg] [int] NULL,
         [Nazev] [nvarchar](100) NOT NULL,
         [DruhyNazev] [nvarchar](100) NOT NULL,
         [Misto] [nvarchar](100) NOT NULL,
         [IdZeme] [nvarchar](3) NULL,
         [Region] [nvarchar](15) NULL,
         [Ulice] [nvarchar](100) NOT NULL,
         [OrCislo] [nvarchar](15) NOT NULL,
         [PopCislo] [nvarchar](15) NOT NULL,
         [PSC] [nvarchar](10) NULL,
         [PoBox] [nvarchar](40) NULL,
         [Kontakt] [nvarchar](40) NULL,
         [DIC] [nvarchar](15) NULL,
         [LhutaSplatnosti] [smallint] NULL,
         [Stav] [tinyint] NOT NULL,
         [PravniForma] [tinyint] NOT NULL,
         [DruhCinnosti] [int] NULL,
         [ICO] [nvarchar](20) NULL,
         [Sleva] [numeric](5, 2) NOT NULL,
         [OdHodnoty] [numeric](19, 6) NOT NULL,
         [CenovaUroven] [int] NULL,
         [IDSOZsleva] [int] NULL,
         [IDSOZnazev] [int] NULL,
         [Poznamka] [ntext] NULL,
         [FormaUhrady] [nvarchar](30) NULL,
         [JeOdberatel] [bit] NOT NULL,
         [JeDodavatel] [bit] NOT NULL,
         [VernostniProgram] [bit] NOT NULL,
         [OdpOs] [int] NULL,
         [Upozorneni] [nvarchar](255) NULL,
         [CisloOrgDos] [nvarchar](20) NOT NULL,
         [Mena] [nvarchar](3) NULL,
         [DatPorizeni] [datetime] NOT NULL,
         [Autor] [nvarchar](128) NOT NULL,
         [DatZmeny] [datetime] NULL,
         [Zmenil] [nvarchar](128) NULL,
         [BlokovaniEditoru] [smallint] NULL,
         [Fakturacni] [bit] NOT NULL,
         [MU] [bit] NOT NULL,
         [Prijemce] [bit] NOT NULL,
         [UdajOZapisuDoObchRej] [nvarchar](128) NOT NULL,
         [IDBankSpojeni] [int] NULL,
         [IDBankSpojPlatak] [int] NULL,
         [CarovyKodEAN] [nvarchar](13) NULL,
         [PostAddress] [nvarchar](255) NOT NULL,
         [Kredit] [numeric](19, 6) NOT NULL,
         [Saldo] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl1] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl2] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl3] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl4] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl5] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl6] [numeric](19, 6) NOT NULL,
         [UhrazenoPredSpl0] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl1] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl2] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl3] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl4] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl5] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl6] [numeric](19, 6) NOT NULL,
         [UhrazenoPoSpl0] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl1] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl2] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl3] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl4] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl5] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl6] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPredSpl0] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl1] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl2] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl3] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl4] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl5] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl6] [numeric](19, 6) NOT NULL,
         [NeuhrazenoPoSpl0] [numeric](19, 6) NOT NULL,
         [FaSumaCelkem] [numeric](19, 6) NULL,
         [PozastavenoCelkem] [numeric](19, 6) NULL,
         [FaAktualizovano] [datetime] NULL,
         [PlneniBezDPH] [bit] NOT NULL,
         [Jazyk] [nvarchar](15) NULL,
         [DatumNeupominani] [datetime] NULL,
         [CenovaUrovenNakup] [int] NULL,
         [TIN] [nvarchar](17) NOT NULL,
         [EvCisDanovySklad] [nvarchar](30) NULL,
         [DICsk] [nvarchar](15) NULL,
         [SlevaSozNa] [tinyint] NULL,
         [SlevaSkupZbo] [tinyint] NULL,
         [SlevaKmenZbo] [tinyint] NULL,
         [SlevaStavSkladu] [tinyint] NULL,
         [SlevaZbozi] [tinyint] NULL,
         [SlevaOrg] [tinyint] NULL,
         [IdTxtPenFak] [int] NULL,
         [Logo] [image] NULL,
         [KorekceSplatnoAuto] [int] NULL,
         [KorekceSplatnoUziv] [int] NULL,
         [NapocetProPT] [tinyint] NOT NULL,
         [DatPorizeni_D]  AS (datepart(day,[DatPorizeni])),
         [DatPorizeni_M]  AS (datepart(month,[DatPorizeni])),
         [DatPorizeni_Y]  AS (datepart(year,[DatPorizeni])),
         [DatPorizeni_Q]  AS (datepart(quarter,[DatPorizeni])),
         [DatPorizeni_W]  AS (datepart(week,[DatPorizeni])),
         [DatPorizeni_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatPorizeni],0),0),0)),
         [DatZmeny_D]  AS (datepart(day,[DatZmeny])),
         [DatZmeny_M]  AS (datepart(month,[DatZmeny])),
         [DatZmeny_Y]  AS (datepart(year,[DatZmeny])),
         [DatZmeny_Q]  AS (datepart(quarter,[DatZmeny])),
         [DatZmeny_W]  AS (datepart(week,[DatZmeny])),
         [DatZmeny_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatZmeny],0),0),0)),
         [KreditZustatek]  AS (CONVERT([numeric](19,6),[Kredit]-[Saldo],0)),
         [FaAktualizovano_D]  AS (datepart(day,[FaAktualizovano])),
         [FaAktualizovano_M]  AS (datepart(month,[FaAktualizovano])),
         [FaAktualizovano_Y]  AS (datepart(year,[FaAktualizovano])),
         [FaAktualizovano_Q]  AS (datepart(quarter,[FaAktualizovano])),
         [FaAktualizovano_W]  AS (datepart(week,[FaAktualizovano])),
         [FaAktualizovano_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[FaAktualizovano],0),0),0)),
         [DatumNeupominani_D]  AS (datepart(day,[DatumNeupominani])),
         [DatumNeupominani_M]  AS (datepart(month,[DatumNeupominani])),
         [DatumNeupominani_Y]  AS (datepart(year,[DatumNeupominani])),
         [DatumNeupominani_Q]  AS (datepart(quarter,[DatumNeupominani])),
         [DatumNeupominani_W]  AS (datepart(week,[DatumNeupominani])),
         [DatumNeupominani_X]  AS (CONVERT([datetime],CONVERT([int],CONVERT([float],[DatumNeupominani],0),0),0)),
         [Logo_DatLen]  AS (isnull(datalength([Logo]),(0))),
         [EORI] [nvarchar](17) NOT NULL,
         [Logo_BGJ]  AS (case when [Logo] IS NULL then NULL else case when substring([Logo],(1),(2))=0x424D then N'Bitmap' else case when substring([Logo],(1),(3))=0x474946 then N'GIF' else case when substring([Logo],(1),(2))=0xFFD8 then N'JPEG' else case when substring([Logo],(1),(4))=0x00000100 then N'Icon' else case when substring([Logo],(1),(8))=0x89504E470D0A1A0A then N'PNG' else case when substring([Logo],(1),(4))=0x54494646 then N'TIFF' else '' end end end end end end end),
         [UliceSCisly]  AS (([Ulice]+N' ')+case when [PopCislo]<>'' AND [OrCislo]<>'' then ([PopCislo]+N'/')+[OrCislo] else [PopCislo]+[OrCislo] end),
         [Firma]  AS (ltrim(substring(replace([Nazev],nchar((13))+nchar((10)),nchar((32))),(1),(100)))),
         [DruhDopravy] [tinyint] NULL,
         [DodaciPodminky] [nvarchar](3) NOT NULL,
         [PostovniAdresa]  AS (CONVERT([nvarchar](255),case when [PostAddress]='' then (((((([Nazev]+nchar((13)))+nchar((10)))+(([Ulice]+nchar((32)))+case when [PopCislo]<>'' AND [OrCislo]<>'' then ([PopCislo]+N'/')+[OrCislo] else [PopCislo]+[OrCislo] end))+nchar((13)))+nchar((10)))+ltrim(isnull([PSC],'')+nchar((32))))+[Misto] else [PostAddress] end,0)),
         [KorekceSplatnoUzivD] [int] NULL,
         [RezimPenalizace] [tinyint] NOT NULL,
         [Penale] [tinyint] NOT NULL,
         [Partner] [nvarchar](3) NULL,
         [PlatceDPH] [bit] NOT NULL,
         [IDSOZExpirace] [int] NULL
  • 8. Re: Encoding issue - query MS SQL data from ORACLE
    kgronau Guru
    Currently Being Moderated
    The workaround is to use the full qualified table name. It doesn't solve the issue in all cases, but it might be worth a try.
    Have a look at your code:
    MERGE INTO HELIOS_TabCisOrg a
    USING (
    select
    'FO' ZDROJ,
    "ID" id,
    "CisloOrg" cisloorg,
    "Nazev" nazev,
    "DruhyNazev" druhynazev,
    "Misto" misto,
    "IdZeme" idzeme,
    "Ulice" ulice,
    "PopCislo" popcislo,
    "PSC" psc,
    "Kontakt" kontakt,
    "DIC" dic,
    "LhutaSplatnosti" lhutasplatnosti,
    "Stav" stav,
    "PravniForma" pravniforma,
    "DruhCinnosti" druhcinnosti,
    "ICO" ico,
    --h."Poznamka",
    "JeOdberatel" jeodberatel,
    "JeDodavatel" jedodavatel,
    "Upozorneni" upozorneni,
    "Mena" mena,
    "DatPorizeni" datporizeni,
    "Autor" autor,
    "DatZmeny" datzmeny,
    "Zmenil" zmenil,
    "UdajOZapisuDoObchRej" udajozapisudoobchrej,
    "Kredit" kredit,
    "Saldo" saldo
    from "TabCisOrg"@HELIOSFO
    ) b

    now replace the table name "TabCisOrg"@HELIOSFO with the full qualified table name "dbo"."TabCisOrg"@HELIOSFO

    So replace ALL table names that use a link to the foreign database and add the owner to the name as well.
  • 9. Re: Encoding issue - query MS SQL data from ORACLE
    Tomeo Newbie
    Currently Being Moderated
    Lucky day for me :-)!

    Adding "dbo". to tablename seems to solve my issue.

    Thanks,
    Tomas
  • 10. Re: Encoding issue - query MS SQL data from ORACLE
    kgronau Guru
    Currently Being Moderated
    Please mark this thread as answered.

    Thanks,
    Klaus

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points