<HTML><HEAD><TITLE>Re: [Gvsig_english] new problems with an oracle layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17063" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText55205>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Kornel. Thanks for doing that test.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Can you do exacty this, please?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- close gvSIG it it's running</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- delete all the log files:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>\home\<user>\gvSIG\*log*</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>- start gvSIG, create a view and add ONLY the table that caused the problem. The layer is visible in the view?</FONT></DIV><FONT face="Times New Roman" color=#000000 size=3></FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>
<DIV>- open the attributes table. How many rows does it have? (it's written in the bottom margin of the attributes table)</DIV>
<DIV> </DIV>
<DIV>- try to export the layer to SHP. When you see the error message, close gvSIG.</DIV>
<DIV> </DIV>
<DIV>- send a ZIP file to the list containing the all the new log files: \home\<user>\gvSIG\*log*</DIV>
<DIV> </DIV>
<DIV>- also, execute these three SQL sentences (replacing the values THE_OWNER and THE_TABLE_NAME with those of the table that caused the problem) and send the result:</DIV>
<DIV> </DIV>
<DIV></FONT><FONT face="Times New Roman" color=#000000 size=3>(1) select COLUMN_NAME from ALL_SDO_GEOM_METADATA where OWNER = 'THE_OWNER' and TABLE_NAME = 'THE_TABLE_NAME'</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(2) desc THE_OWNER.THE_TABLE_NAME</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(3) select count(*) FROM THE_OWNER.THE_TABLE_NAME</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3> </DIV></DIV>
<DIV>
<DIV><BR>Regards,</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature67371>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de K.Kiss<BR><B>Enviado el:</B> vie 18/06/2010 11:31<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] new problems with an oracle layer<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>hello,<BR><BR>i have executed: "select * from PLAN.GRUEN_POLY t where t.SHAPE.SDO_GTYPE<BR>= NULL"<BR><BR>oracle return: NULL<BR>-------------------------------------------------------<BR>The next test:<BR>CREATE TABLE validate_results(sdo_rowid ROWID, status VARCHAR2(2000))<BR>/<BR>SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('PLAN.GRUEN_POLY', 'SHAPE',<BR>'validate_results');<BR>/<BR>SELECT * FROM validate_results ORDER BY status<BR>/<BR><BR>At the moment a have a problem with the same user<BR>1.) to create the table " validate_results" ["insufficient rights" ]<BR>and<BR>2.) to read from "PLAN.GRUEN_POLY". (the reading is for our default user<BR>ok) <BR><BR><BR>( The other user can create and write, but can not read from<BR>"PLAN.GRUEN_POLY"....)<BR> It must be changed.........<BR><BR>greetings from munich<BR><BR>-----<BR>Kornel Kiss<BR><BR>Referat für Gesundheit und Umwelt<BR>Anforderungsmanagement Fachanwendungen<BR>Bayerstr. 28a<BR>80335 München<BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5194638.html">http://osgeo-org.1803224.n2.nabble.com/new-problems-with-an-oracle-layer-tp5190806p5194638.html</A><BR>Sent from the gvSIG international mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>