[Qgis-user] WG: Adding a Oracle Spatial Layer without a SRID Value at the geometry column

[Anger Johannes]

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: johannes.anger at brawag.de
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: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] Im Auftrag von Jürgen E. Fischer
Gesendet: Mittwoch, 15. Juli 2015 23:10
An: qgis-user at lists.osgeo.org
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