Beginning HTML with CSS and XHTML incorporates practical examples that will show you how to structure your data correctly using (X)HTML, together with styling and layout basics using CSS. It also shows how to add dynamic behavior to your data using the JavaScript. language. All of the featured code and techniques are standards compliant and demonstrate best practices.so you will not waste time on any outdated techniques.

Errata Submission

If you think that you've found an error in Pro Oracle Spatial for Oracle Database 11g, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

Errata

Issue	Author's Response
Your book indicates that “Updated for Oracle Database 11g” How about your examples and dump files? I suspect you haven’t tested them against 11g . I just started reading your book and trying to import those dump files per your instruction. Dump files will not import to 11g. There will be a bunch of errors: Here is just one of them. MP-00060: Warning: Skipping table "SPATIAL"."GC_ROAD_SEGMENT_US" because obje type "MDSYS"."SDO_ORDINATE_ARRAY" does not exist or has different identifier . importing table "GC_ROAD_US" 5451 rows imported MP-00017: following statement failed with ORACLE error 942: "CREATE INDEX "GC_ROAD_SEGMENT_US_SIDX" ON "GC_ROAD_SEGMENT_US" ("GEOMETRY" " ") INDEXTYPE IS "MDSYS"."SPATIAL_INDEX"	I am surprised that you have this problem. I just downloaded the files again from the Apress site and imported them successfully in my local 11g database. The exports were done using the 10g export tool on purpose, so that they could also be used in 10g databases, and still be imported in 11.1 ( as well as subsequent versions). There have been bugs that result in the kind of error you see, but they had to do with IMPDP and transportable tablespaces, not IMP. I suspect your problem is simpler: please verify that you have Oracle Spatial enabled in your database. You can check this by just logging in (as SCOTT for example), then doing SQL> describe sdo_geometry If this fails (= ORA-04043: object sdo_geometry does not exist) then this explains the problem. Simplest then is to use the database configuration assistant and add spatial support to your database. Albert albert.godfrind@gmail.com
chapter 8, page 264, Listing 8-29. The accompanying text says the "order of the neighbors returned...is not the same as in Listing 8-26..." but they are the same.	Thanks for spotting this.
Chapter 8, page 250. Listing 8-11 includes "WORK_TABLESPACE=SYSAUX" but the accompanying paragraph reads "In this example, WORK_TABLESPACE=TBS_3..."	Thanks for noting this!
the citybldgs.dmp file is corrupt. How can I get a good copy? imp spatial/spatial file=citybldgs.dmp full=y Import: Release 10.2.0.4.0 - Production on Tue May 26 08:45:30 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully	This dump file was exported using the 11g export, and therefore can only be imported using an import of version 11.1 or later; You are trying to import using a 10gR2 import,, which is not possible and will fail as indicated. Notice that this file contains 3D building shapes, which are only valid in 11g and later anyway. Albert
chapter 6, page 173. Listing 6-12 is missing the "MATCHVECTOR" - MATCHVECTOR ????0101010??002?	Well spotted!
chapter 2, page 25. Listing 2.5 is missing the "distance" column in the query result.	You mean listing 2-4 ? The distance is actually not selected in the query, only POI_NAME is selected. The distance is only used in the subquery in order to sort the results. Then the rownum predicate is applied on the result of the subquery in order to limit the answer to 5 POIs. Albert
I've found a problem with de styles.dmp file, which is included in the source code files set. The file doesn´t have the table 'my_cached_maps', like described in chapter 12, page 445. Thanks.	That is correct. My apologies for that mistake. I will upload a new copy of the file. Albert
page 40 code List 3-5 Geocoding Addresses to Obtain Explicit Spatial Information error information from oracle rror starting at line 2 in command: UPDATE customers SET location = SDO_GCDR.GEOCODE_AS_GEOMETRY ( 'SPATIAL', SDO_KEYWORDARRAY ( street_number || ` ` || street_name, city || `, ` || state || ` ` || postal_code ), 'US' ) Error at Command Line:9 Column:18 Error report: SQL Error: ORA-00911: invalid character 00911. 00000 - "invalid character" *Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#...#') cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. *Action:	It looks like you are doing a cut and paste from the PDF book ? I am getting a similar error when doing this. The reason is that the string delimiters (that should be a quote character) are not really all quote characters in the line that builds the keyword array by concatenation. This seems to be the only listing in the book with that problem. Sorry about that. You will need to manually replace those quotes, or take the actual source code from the downloaded examples. Here is the corrected listing: UPDATE customers SET location = SDO_GCDR.GEOCODE_AS_GEOMETRY ( 'SPATIAL', SDO_KEYWORDARRAY ( street_number || ' ' || street_name, -- add whitespace to separate out street_number and street_name city || ', ' || state || ' ' || postal_code ), 'US' ) ;
Hi, I tried to install the web example that you provided with the book, but I have the following error : "No such base map: spatial.us_detailed_map". I noticed that the MY_CACHED_MAPS was not included in the styles.dmp file. I was then not able to execute completely the listing 12-2. Can it be the problem? Can I have a dump with the MY_CACHED_MAPS included? Thanks a lot	Sorry about that. We will upload a corrected copy of the STYLES.DMP file as soon as possible.