I have table that create from shp2sdo and migrate to oracle
and add featuretype and display correctly.
then that I add table not spatial data and create view in oracle and add
featuretype and display correctly.
this is my sql that create view
create or replace view cw_sale_indust_c02 as
select emp.data,
ch.prov_name,
clust.value clustname,
boundary.geom
from changwat_sale emp,
changwat_cluster clust,
changwat ch,
changwat_boundary boundary
where emp.cluster_id = clust.id
and type = 1
and emp.cluster_id=2
and emp.prov_id = ch.prov_code
and emp.prov_id = boundary.prov_code
and this is sql that insert user_sdo_geom_metadata
INSERT INTO user_sdo_geom_metadata
(table_name, column_name, diminfo, srid)
SELECT 'cw_sale_indust_c02', column_name, diminfo, srid
FROM user_sdo_geom_metadata WHERE table_name = 'CHANGWAT_BOUNDARY'
then I want another featuretype so I created view with same sql by changed
view name and use same sld
but It don't display correctly by show blank screen.
Did I make something wrong and how do I solve?
--
View this message in context: http://www.nabble.com/problem-with-view-on-oracle-t1548304.html#a4205915
Sent from the GeoServer - User forum at Nabble.com.