Comments (6)
from 3dcitydb.
I still got compilation errors under Oracle 11g. I had to create a variable within the anynomous code blocks:
:GEORASTER_SUPPORT := :GEORASTER_SUPPORT;
The special treatment for GEORASTER is also missing in other files, like DROP_DB. Everything is already fixed in the dev branch by c0eb7ec.
Will close issue as soon as code is merged.
from 3dcitydb.
Just ran the setup on Oracle 11g without compilation errors (using latest master). What errors do you encounter? And GEORASTER_SUPPORT is considered in the DROP_DB script. Please provide more information.
from 3dcitydb.
When dropping the schema the following messages appear in the log:
"SP2-0552: Bind-Variable "GEORASTER_SUPPORT" ist nicht deklariert"
I've included a declaration of GEORASTER_SUPPORT in DROP_DB.sql in order to use &GEORASTER_SUPPORT in DROP_DB2.sql. Then I do not need to define the variable in all the code blocks.
When creating the DB I spot several errors in the logs, but for some reasons it says "finished without errors" in the end. I fixed it by adding a declaration in most code blocks.
Fehler beim Start in Zeile : 777 Datei @ C:\Users\fkunde\workspace\citydb\Oracle\SQLScripts\SCHEMA\TABLES\TABLES.sql In Befehl - BEGIN IF (upper('&DBVERSION')='S' and :GEORASTER_SUPPORT <> 0) THEN EXECUTE IMMEDIATE 'CREATE TABLE RASTER_RELIEF ( ID NUMBER NOT NULL , URI VARCHAR2(4000) , COVERAGE_ID NUMBER , CONSTRAINT RASTER_RELIEF_PK PRIMARY KEY ( ID ) ENABLE )'; EXECUTE IMMEDIATE 'CREATE TABLE GRID_COVERAGE ( ID NUMBER NOT NULL , RASTERPROPERTY MDSYS.SDO_GEORASTER NOT NULL , CONSTRAINT GRID_COVERAGE_PK PRIMARY KEY ( ID ) ENABLE )'; EXECUTE IMMEDIATE 'CREATE TABLE GRID_COVERAGE_RDT ( RASTERID NUMBER , PYRAMIDLEVEL NUMBER , BANDBLOCKNUMBER NUMBER , ROWBLOCKNUMBER NUMBER , COLUMNBLOCKNUMBER NUMBER , BLOCKMBR MDSYS.SDO_GEOMETRY , RASTERBLOCK BLOB , CONSTRAINT GRID_COVERAGE_RDT_PK PRIMARY KEY ( RASTERID , PYRAMIDLEVEL , BANDBLOCKNUMBER , ROWBLOCKNUMBER , COLUMNBLOCKNUMBER ) ENABLE ) LOB (RASTERBLOCK) STORE AS SECUREFILE ( ENABLE STORAGE IN ROW CACHE )'; END IF; END; Fehlerbericht - Fehlende Defines
Fehler beim Start in Zeile : 42 Datei @ C:\Users\fkunde\workspace\citydb\Oracle\SQLScripts\SCHEMA\SEQUENCES\SEQUENCES.sql In Befehl - BEGIN IF (upper('&DBVERSION')='S' and :GEORASTER_SUPPORT <> 0) THEN EXECUTE IMMEDIATE 'CREATE SEQUENCE GRID_COVERAGE_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE'; EXECUTE IMMEDIATE 'CREATE SEQUENCE GRID_COVERAGE_RDT_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCACHE'; END IF; END; Fehlerbericht - Fehlende Defines
Fehler beim Start in Zeile : 1.733 Datei @ C:\Users\fkunde\workspace\citydb\Oracle\SQLScripts\SCHEMA\CONSTRAINTS\CONSTRAINTS.sql In Befehl - BEGIN IF (upper('&DBVERSION')='S' and :GEORASTER_SUPPORT <> 0) THEN EXECUTE IMMEDIATE 'ALTER TABLE RASTER_RELIEF ADD CONSTRAINT RASTER_RELIEF_COMP_FK FOREIGN KEY ( ID ) REFERENCES RELIEF_COMPONENT ( ID ) ENABLE'; EXECUTE IMMEDIATE 'ALTER TABLE RASTER_RELIEF ADD CONSTRAINT RASTER_RELIEF_COVERAGE_FK FOREIGN KEY ( COVERAGE_ID ) REFERENCES GRID_COVERAGE ( ID ) ENABLE'; END IF; END; Fehlerbericht - Fehlende Defines
Fehler beim Start in Zeile : 314 Datei @ C:\Users\fkunde\workspace\citydb\Oracle\SQLScripts\SCHEMA\INDEXES\SIMPLE_INDEX.sql In Befehl - BEGIN IF (upper('&DBVERSION')='S' and :GEORASTER_SUPPORT <> 0) THEN EXECUTE IMMEDIATE 'CREATE INDEX RASTER_RELIEF_COVERAGE_FKX ON RASTER_RELIEF (COVERAGE_ID)'; END IF; END; Fehlerbericht - Fehlende Defines
plus at the end I see comething, I haven't noticed before:
MC2 -------------------------------------------------------------------------------- 1 Zeilen gewählt SP2-0556: Ungültiger Dateiname.
from 3dcitydb.
Strange, no errors on my side
from 3dcitydb.
Should be fixed now :)
from 3dcitydb.
Related Issues (20)
- Enhance Github labels
- Github issue form templates
- High number of export files HOT 6
- [Question] CityGML coordinates understanding problem HOT 2
- rename "val_reference_type" to "feature_reference_type" HOT 1
- change index on "name" column of "property"
- Change xal_source column of address to support more content besides xAL
- Remove column supertype_id of table datatype HOT 2
- Export of 2D building geometries (groundfloor, upperfloor, roofs) as geojson? HOT 6
- Drop the "type" column from the geometry_data table
- Drop "val_implicitgeom_transform" column HOT 1
- Change gt_orientation to json HOT 1
- Drop "val_implicitgeom_refpoint" coulmn?
- Data creation learning-curve barrier HOT 3
- Some changes to indexes HOT 1
- Drop the "objectid" column from the geometry_data table HOT 1
- Minor changes to "property" table HOT 2
- Resolve inconsistency between objectclass and datatype HOT 2
- Harmonize file names and directory names HOT 3
- Error on import of 2.0 model HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from 3dcitydb.