<HTML><HEAD><TITLE>Re: [Gvsig_english] gvSIG, Oracle Spatial and Views</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText5024>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Kornel.</FONT></DIV>
<DIV> </DIV>
<DIV>Excuse me, I still have not explained something important:</DIV>
<DIV> </DIV>
<DIV>- The option "Table - New - Database" does not work properly, I'm sorry, so you cannot add alphanumeric Oracle tables (without geometry) to gvSIG. The error message shown in the log file sent by Wolfgagng is caused by this.</DIV>
<DIV> </DIV>
<DIV>- The option "Add layer - GeoBD" should work. After your last test, we must think that your view does have ROWID field, so it should be available from gvSIG if it's listed in the Oracle metadata, as I said before. You will probably to do a manual INSERT INTO...:</DIV>
<DIV> </DIV>
<DIV><A href="http://listserv.gva.es/pipermail/gvsig_internacional/2010-February/004874.html">http://listserv.gva.es/pipermail/gvsig_internacional/2010-February/004874.html</A></DIV>
<DIV> </DIV>
<DIV>(obviously, it must have a geometry column (type SDO_GEOMETRY))</DIV>
<DIV> </DIV>
<DIV>regards,</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature13064>
<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> mar 23/02/2010 15:37<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] gvSIG, Oracle Spatial and Views<BR></FONT><BR></DIV>
<DIV><BR>
<P><FONT size=2>Hello,<BR><BR>I´m Kornel and the colleague of the Wolfgang in munich.<BR>I´ve tested the oracle-statement again, and it works. The tool "Toad" hide<BR>normally<BR>the "ROWID"-column and display only "NULL".<BR><BR>But in the mode "execute as skript" :<BR><BR>select rowid from uis_gis_muc_mobilfunkanl_v_r<BR><BR><BR>ROWID<BR>------------------<BR>AAAXdQAAGAAAQwDAAk<BR>AAAXdQAAGAAAQwDAAl<BR>AAAXdQAAGAAAQwDAAm<BR>AAAXdQAAGAAAQwDAAn<BR>AAAXdQAAGAAAQwDAAo<BR>AAAXdQAAGAAAQwDAAp<BR><BR>1007 Rows selected.<BR><BR>it worked!<BR><BR>Thanks for the moment. If i have new informations i would it post here.<BR>--<BR>View this message in context: <A href="http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4619150.html">http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4619150.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>