Hi Jürgen,

it's a long list. The columns are defined by the main GIS in our company. 

Best regards,
Joe

Columns

C01     VARCHAR2
C02     VARCHAR2
C03     VARCHAR2
C04     VARCHAR2
C05     VARCHAR2
C06     VARCHAR2
C07     VARCHAR2
C08     VARCHAR2
C09     VARCHAR2
C10     VARCHAR2
C11     VARCHAR2
C12     VARCHAR2
C13     VARCHAR2
C14     VARCHAR2
C15     VARCHAR2
C16     VARCHAR2
C17     VARCHAR2
C18     VARCHAR2
C19     VARCHAR2
C20     VARCHAR2
C21     VARCHAR2
C22     VARCHAR2
C23     VARCHAR2
C24     VARCHAR2
C25     VARCHAR2
C26     VARCHAR2
C27     VARCHAR2
C28     VARCHAR2
C29     VARCHAR2
C30     VARCHAR2
C31     VARCHAR2
C32     VARCHAR2
C33     VARCHAR2
C34     VARCHAR2
C35     VARCHAR2
C36     VARCHAR2
C37     VARCHAR2
C38     VARCHAR2
C39     VARCHAR2
C40     VARCHAR2
C41     VARCHAR2
C42     VARCHAR2
C43     VARCHAR2
C44     VARCHAR2
C45     VARCHAR2
C46     VARCHAR2
C47     VARCHAR2
C48     VARCHAR2
C49     VARCHAR2
C50     VARCHAR2
N01     NUMBER
N02     NUMBER
N03     NUMBER
N04     NUMBER
N05     NUMBER
N06     NUMBER
N07     NUMBER
N08     NUMBER
N09     NUMBER
N10     NUMBER
N11     NUMBER
N12     NUMBER
N13     NUMBER
N14     NUMBER
N15     NUMBER
N16     NUMBER
N17     NUMBER
N18     NUMBER
N19     NUMBER
N20     NUMBER
N21     NUMBER
N22     NUMBER
N23     NUMBER
N24     NUMBER
N25     NUMBER
N26     NUMBER
N27     NUMBER
N28     NUMBER
N29     NUMBER
N30     NUMBER
N31     NUMBER
N32     NUMBER
N33     NUMBER
N34     NUMBER
N35     NUMBER
N36     NUMBER
N37     NUMBER
N38     NUMBER
N39     NUMBER
N40     NUMBER
N41     NUMBER
N42     NUMBER
N43     NUMBER
N44     NUMBER
N45     NUMBER
N46     NUMBER
N47     NUMBER
N48     NUMBER
N49     NUMBER
N50     NUMBER
D01     DATE
D02     DATE
D03     DATE
D04     DATE
D05     DATE
D06     DATE
D07     DATE
D08     DATE
D09     DATE
D10     DATE
D11     DATE
D12     DATE
D13     DATE
D14     DATE
D15     DATE
D16     DATE
D17     DATE
D18     DATE
D19     DATE
D20     DATE
GEO     SDO_GEOMETRY                    
GK      VARCHAR2        
LK      VARCHAR2
VAM     VAM_ATTRIBUT_ARRAY
CG101   VARCHAR2
CG102   VARCHAR2
CG103   VARCHAR2
NG103   NUMBER
DG103   DATE
CG210   VARCHAR2
CG211   VARCHAR2
CG212   VARCHAR2
CG213   VARCHAR2
CG218   VARCHAR2
CG219   VARCHAR2
CG113   VARCHAR2
CG110   VARCHAR2
CG111   VARCHAR2
CG112   VARCHAR2
NG101   NUMBER
NG014   NUMBER
CG114   VARCHAR2
CG115   VARCHAR2
C51     VARCHAR2
C52     VARCHAR2
C53     VARCHAR2
C54     VARCHAR2
C55     VARCHAR2
C56     VARCHAR2
C57     VARCHAR2
C58     VARCHAR2
C59     VARCHAR2
C60     VARCHAR2
C61     VARCHAR2
C62     VARCHAR2
C63     VARCHAR2
C64     VARCHAR2
C65     VARCHAR2
C66     VARCHAR2
C67     VARCHAR2
C68     VARCHAR2
C69     VARCHAR2
N51     NUMBER
N52     NUMBER
N53     NUMBER
N54     NUMBER
N55     NUMBER
N56     NUMBER
N57     NUMBER
N58     NUMBER
N59     NUMBER
N81     NUMBER
N82     NUMBER
N83     NUMBER
N84     NUMBER
N85     NUMBER
N86     NUMBER
N87     NUMBER
N88     NUMBER
N89     NUMBER
D30     DATE
NG220   NUMBER
NG221   NUMBER
NG222   NUMBER
NG223   NUMBER
NG224   NUMBER
NG225   NUMBER
NG108   NUMBER
C86     VARCHAR2
C87     VARCHAR2
C88     VARCHAR2
C76     VARCHAR2
CG132   VARCHAR2
CG170   VARCHAR2
CG217   VARCHAR2
CG230   VARCHAR2
CG231   VARCHAR2
CG232   VARCHAR2
NG217   NUMBER
NG226   NUMBER
NG227   NUMBER
DG112   DATE
DG117   DATE
CG216   VARCHAR2
NG216   NUMBER
NG218   NUMBER
CG215   VARCHAR2
NG228   NUMBER
C77     VARCHAR2

Mit freundlichen Grüßen 

Johannes Anger
 
BRAWAG GmbH
Wasser- und Abwassergesellschaft
Brandenburg an der Havel
Technischer Bereich
Tel.: 03381 543-688
Fax: 03381 543-622
E-Mail: [email protected]
Internet: www.brawag.de

Sitz der Gesellschaft Brandenburg an der Havel
Registergericht: Amtsgericht Potsdam HRB 6722
Geschäftsführer: Uwe Müller

-----Ursprüngliche Nachricht-----
Von: [email protected] 
[mailto:[email protected]] Im Auftrag von Jürgen E. Fischer
Gesendet: Mittwoch, 15. Juli 2015 23:10
An: [email protected]
Betreff: Re: [Qgis-user] Adding a Oracle Spatial Layer without a SRID Value at 
the geometry column

Hi Joe,

On Wed, 15. Jul 2015 at 03:02:41 -0700, johannes wrote:
> ..\..\..\..\..\..\..\src\providers\oracle\ocispatial\qsql_ocispatial.cpp:
> 3011: (QOCISpatialResult::gotoNext) goto next error:  [ORA-00932:
> Inkonsistente Datentypen: BLOB erwartet, ARRAY erhalten]/

What columns does the table have?

Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode     
                    
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to